Cluster upgrades in Azure Cosmos DB for PostgreSQL

APPLIES TO: Azure Cosmos DB for PostgreSQL (powered by the Citus database extension to PostgreSQL)

The Azure Cosmos DB for PostgreSQL managed service can handle upgrades of both the PostgreSQL server, and the Citus extension. You can choose these versions mostly independently of one another, except Citus 11 requires PostgreSQL 13 or higher.

Upgrade precautions

Upgrades require some downtime in the database cluster. The exact time depends on the source and destination versions of the upgrade. To prepare for the production cluster upgrade, we recommend testing the upgrade, and measure downtime during the test.

Also, upgrading a major version of Citus can introduce changes in behavior. It's best to familiarize yourself with new product features and changes to avoid surprises.

Noteworthy Citus 11 changes:

• Table shards may disappear in your SQL client. Their visibility is now controlled by citus.show_shards_for_app_name_prefixes.
• There are several deprecated features.

Next steps

How to perform upgrades