Edit

Major version upgrade

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 Azure Database for PostgreSQL flexible server that 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 server status must be Ready 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.

    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. For Action, select Validate and upgrade to run the validation rules and, if they all pass, it immediately upgrades the server to the selected target version. It warns you about the consequences of initiating the upgrade.

    Screenshot showing the Action option configured as Validate and upgrade.

  8. Select Start.

    Screenshot showing the Start button, to initiate the upgrade.

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

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

  10. When the upgrade finishes, you 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.

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

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