APPLIES TO: PostgreSQL
These instructions describe how to upgrade to a new major version of PostgreSQL on all cluster nodes.
Test the upgrade first
Upgrading PostgreSQL causes more changes than you might imagine, because Azure Cosmos DB for PostgreSQL will also upgrade the database extensions, including the Citus extension. Upgrades also require downtime in the database cluster.
We strongly recommend you to test your application with the new PostgreSQL and Citus version before you upgrade your production environment. Also, see our list of upgrade precautions.
A convenient way to test is to make a copy of your cluster using point-in-time restore. Upgrade the copy and test your application against it. Once you've verified everything works properly, upgrade the original cluster.
Upgrade a cluster in the Azure portal
- In the Overview section of a cluster, select the Upgrade button.
- A dialog appears, showing the current version of PostgreSQL and Citus. Choose a new PostgreSQL version in the PostgreSQL version to upgrade list.
- Verify that the value in Citus version to upgrade is what you expect. This value changes based on the PostgreSQL version you selected.
- Select the Upgrade button to continue.
If you're already running the latest PostgreSQL version, the selection and button are grayed out.