Vultr DocsLatest Articles

How to Manage Upgrade Window for Vultr Managed Databases for PostgreSQL

Updated on November 27, 2024

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, and CLI.

  • Vultr Customer Portal
  • Vultr API
  • Vultr CLI

  1. Navigate to Products and select Databases.

  2. Click the target database instance.

    Select Managed Database

  3. Click Settings and Upgrade Window. Select the day of the week and the time and click Apply Changes.

    Edit Upgrade Window

  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.