Major version upgrade of Azure Database for PostgreSQL - Flexible Server

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

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

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.

Follow these steps to upgrade your Azure Database for PostgreSQL flexible server instance to the major version of your choice:

  1. In the Azure portal, choose the Azure Database for PostgreSQL flexible server instance that you want to upgrade.

  2. Select Overview from the left pane, and then select Upgrade.

    Diagram of Upgrade tab to perform in-place major version upgrade.

  3. You see an option to select the major version of your choice, you have an option to skip versions to directly upgrade to higher versions. Choose the version and click Upgrade

Diagram of PostgreSQL version to Upgrade.

  1. 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.

  1. Once the upgrade is successful,you can expand the Deployment details tab and click Operation details to see more information about upgrade process like duration, provisioning state etc.

Diagram of successful deployment of for Major Version Upgrade.

  1. You can click on the Go to resource tab to validate your upgrade. You notice that server name remained unchanged and PostgreSQL version upgraded to desired higher version with the latest minor version

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

Next steps