Major version upgrade
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:
Select the instance of Azure Database for PostgreSQL flexible server which you want to upgrade.
From the resource menu, select Overview.
The status of the server must be Available, for the Upgrade button to be enabled.
Select Upgrade.
The Upgrade pane provides some recommendations, and warns you about the consequences of initiating the upgrade.
Expand PostgreSQL version to upgrade, and select the major version to which you want to upgrade.
Select Upgrade.
During upgrade, users have to wait for the process to complete. You can resume accessing the server when the server is back online.
Once the upgrade completes successfully, you can expand Deployment details.
Select Operation details if you want to see more information about the upgrade process.
Then, you can select the Go to resource button to validate your upgrade.
Observe that the name of the server remains unchanged.
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.
Related content
- Overview of business continuity with Azure Database for PostgreSQL - Flexible Server.
- Major version upgrades in Azure Database for PostgreSQL - Flexible Server.
- High availability in Azure Database for PostgreSQL - Flexible Server.
- Backup and restore in Azure Database for PostgreSQL - Flexible Server.