Edit

Share via

Major version upgrade

  • Article

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

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

Note

The major version upgrade action is irreversible. Make sure that you perform a point in time restore (PITR) of the production server that you want to upgrade. Test the upgrade in that restored, nonproduction instance before you upgrade the 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, and select Upgrade.

    Screenshot of the Upgrade pane, from where you can select the 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 when 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. You can see details 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. Observe that the name of the server remains unchanged, and PostgreSQL version is upgraded to the desired target major version. The minor version corresponds to the most recent minor version supported by Azure Database for PostgreSQL - Flexible Server at the time of the upgrade.

    Diagram of upgraded version to Azure Database for PostgreSQL flexible server, after major version upgrade.

Related content