Edit

Share via

Major version upgrade of Azure Database for PostgreSQL - Flexible Server

  • Article

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article provides a step-by-step procedure to perform a major version upgrade of an Azure Database for PostgreSQL flexible server instance.

Note

The major version upgrade action is irreversible. Please perform a Point-In-Time Recovery (PITR) of your production server and test the upgrade in the non-production environment.

Upgrade to the major version of your choice

Using the Azure portal:

  1. Select the instance of Azure Database for PostgreSQL flexible server which you want to upgrade.

  2. From the resource menu, select Overview, and then select Upgrade.

    Screenshot of Overview page to demonstrate how to initiate major version upgrade of an instance of Azure Database for PostgreSQL Flexible Server.

  3. Choose the major version to which you want to upgrade your instance, and click Upgrade.

    Screenshot of the Upgrade pane from where you can select target major version to which you want to upgrade.

  4. During upgrade, users have to wait for the process to complete. You can resume accessing the server once the server is back online.

    Diagram of deployment progress for Major Version Upgrade.

  5. Once the upgrade completes successfully, you can expand Deployment details, and select Operation details to see more information about the upgrade process, like duration, provisioning state, etc. Then you can select the Go to resource button to validate your upgrade.

    Diagram of successful deployment of for Major Version Upgrade.

  6. Notice that the name of the server remains unchanged and PostgreSQL version upgraded to desired target version, with the latest minor version.

    Diagram of Upgraded version to Azure Database for PostgreSQL flexible server after Major Version Upgrade.

Share your suggestions and bugs with the Azure Database for PostgreSQL product team.

Related content