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.

Steps to upgrade to a higher major version

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.

    Screenshot showing the Overview page, to demonstrate how to initiate major version upgrade of an Azure Database for PostgreSQL flexible server.

  3. The status of the server must be Available, for the Upgrade button to be enabled.

    Screenshot showing where in the Overview page you can find the status of the server.

  4. Select Upgrade.

    Screenshot showing the Upgrade button through which you can initiate the major version upgrade of an Azure Database for PostgreSQL flexible server.

  5. The Upgrade pane provides some recommendations, and warns you about the consequences of initiating the upgrade.

    Screenshot showing the Upgrade pane.

  6. Expand PostgreSQL version to upgrade, and select the major version to which you want to upgrade.

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

  7. Select Upgrade.

    Screenshot showing the Upgrade button, to initiate the upgrade.

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

    Screenshot showing of progress of the deployment initiated to perform the major version upgrade.

  9. Once the upgrade completes successfully, you can expand Deployment details.

    Screenshot showing how to expand the deployment details after a successful deployment of a major version upgrade.

  10. Select Operation details if you want to see more information about the upgrade process.

    Screenshot showing how access the operation details of a successful deployment of a major version upgrade.

  11. Then, you can select the Go to resource button to validate your upgrade.

    Screenshot showing the Go to resource button, through which you can access the Overview page of the upgraded Azure Database for PostgreSQL flexible server.

  12. Observe that the name of the server remains unchanged.

    Screenshot showing the Overview page of the upgraded Azure Database for PostgreSQL flexible server, after major version upgrade, highlighting the name of the server.

  13. Notice that the version of PostgreSQL is upgraded to the major version you selected as target. The minor version corresponds to the most recent minor version supported by Azure Database for PostgreSQL - Flexible Server at the time of the upgrade.

    Screenshot showing the Overview page of the upgraded Azure Database for PostgreSQL flexible server, after major version upgrade, highlighting the version of the server.

Related content