How to Manage Upgrade Window for Vultr Managed Databases for PostgreSQL

Updated on 28 August, 2025

Managing the Upgrade window for Vultr Managed Databases for PostgreSQL allows you to set a suitable day and time when your managed database upgrades to the newest version. Upgrading improves security, fixes bugs, and downloads new features. You should set the upgrade schedule when your database application is less busy to avoid downtime for the end-users.

Follow this guide to manage upgrade window for Vultr Managed Databases for PostgreSQL using Vultr Customer Portal, API, CLI, or Terraform.

  • Vultr Customer Portal
  • Vultr API
  • Vultr CLI
  • Terraform
  1. Navigate to Products and select Databases.
  2. Click the target database instance.
  3. Click Settings and Upgrade Window.
  4. Select the day of the week and the time and click Apply Changes.
  1. List all the database instances by sending a GET request to the List Managed Databases endpoint and note the database ID. For example, 43b4c774-5dff-4ac0-a01f-78a23c2205b5.

    console
    $ curl "https://api.vultr.com/v2/databases" \
        -X GET \
        -H "Authorization: Bearer ${VULTR_API_KEY}"
    
  2. Send a PUT request to the Update Managed Database endpoint to change the maintenance day of the week (maintenance_dow) and time (maintenance_time) for the database and specify the database ID.

    console
    $ curl "https://api.vultr.com/v2/databases/database_id" \
        -X PUT \
        -H "Authorization: Bearer ${VULTR_API_KEY}" \
        -H "Content-Type: application/json" \
        --data '{
            "maintenance_dow" : "sunday",
            "maintenance_time" : "01:00"       
        }'
    

    Visit the Update Managed Database endpoint to view additional attributes to add to your request.

  1. List all database instances and note the database ID. For instance, d6ac2a3c-92ea-43ef-8185-71a23e58ad8c.

    console
    $ vultr-cli database list --summarize
    
  2. Update the maintenance day of the week and time by specifying the database ID.

    console
    $ vultr-cli database update database_id \
    --maintenance-dow sunday \
    --maintenance-time 01:00
    

    Run vultr-cli database update --help to view all options.

  1. Open your Terraform configuration for the existing Managed Database for PostgreSQL resource.

  2. Add or update the maintenance_dow and maintenance_time arguments.

    terraform
    resource "vultr_database" "pg" {
        # ...existing fields (database_engine, region, plan, label, etc.)
    
        maintenance_dow  = "sunday"
        maintenance_time = "01:00"
    }
    
  3. Apply the configuration and observe the following output:

    Apply complete! Resources: 0 added, 1 changed, 0 destroyed.

Comments

No comments yet.