Edit

Supported database versions in Azure Cosmos DB for PostgreSQL

  • Article
  • 3 minutes to read

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

PostgreSQL versions

The version of PostgreSQL running in a cluster is customizable during creation. Azure Cosmos DB for PostgreSQL currently supports the following major PostgreSQL versions:

PostgreSQL version 15

The current minor release is 15.2. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 14

The current minor release is 14.7. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 13

The current minor release is 13.10. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 12

The current minor release is 12.14. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 11

The current minor release is 11.19. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 10 and older

We don't support PostgreSQL version 10 and older for Azure Cosmos DB for PostgreSQL.

PostgreSQL version syntax

Before PostgreSQL version 10, the PostgreSQL versioning policy considered a major version upgrade to be an increase in the first or second number. For example, 9.5 to 9.6 was considered a major version upgrade. As of version 10, only a change in the first number is considered a major version upgrade. For example, 10.0 to 10.1 is a minor release upgrade. Version 10 to 11 is a major version upgrade.

PostgreSQL version support and retirement

Each major version of PostgreSQL will be supported by Azure Cosmos DB for PostgreSQL from the date on which Azure begins supporting the version until the version is retired by the PostgreSQL community. Refer to PostgreSQL community versioning policy.

Azure Cosmos DB for PostgreSQL automatically performs minor version upgrades to the Azure preferred PostgreSQL version as part of periodic maintenance.

Major version retirement policy

The table below provides the retirement details for PostgreSQL major versions in Azure Cosmos DB for PostgreSQL. The dates follow the PostgreSQL community versioning policy.

Version What's New Supported since Retirement date (Azure)
PostgreSQL 11 Features May 7, 2019 Nov 9, 2023
PostgreSQL 12 Features Apr 6, 2021 Nov 14, 2024
PostgreSQL 13 Features Apr 6, 2021 Nov 13, 2025
PostgreSQL 14 Features Oct 1, 2021 Nov 12, 2026
PostgreSQL 15 Features Oct 20, 2022 Nov 11, 2027

Retired PostgreSQL engine versions not supported in Azure Cosmos DB for PostgreSQL

You may continue to run the retired version in Azure Cosmos DB for PostgreSQL. However, note the following restrictions after the retirement date for each PostgreSQL database version:

  • As the community will not be releasing any further bug fixes or security fixes, Azure Cosmos DB for PostgreSQL will not patch the retired database engine for any bugs or security issues, or otherwise take security measures with regard to the retired database engine. You may experience security vulnerabilities or other issues as a result. However, Azure will continue to perform periodic maintenance and patching for the host, OS, containers, and any other service-related components.
  • If any support issue you may experience relates to the PostgreSQL engine itself, as the community no longer provides the patches, we may not be able to provide you with support. In such cases, you will have to upgrade your database to one of the supported versions.
  • You will not be able to create new database servers for the retired version. However, you will be able to perform point-in-time recoveries and create read replicas for your existing servers.
  • New service capabilities developed by Azure Cosmos DB for PostgreSQL may only be available to supported database server versions.
  • Uptime SLAs will apply solely to Azure Cosmos DB for PostgreSQL service-related issues and not to any downtime caused by database engine-related bugs.
  • In the extreme event of a serious threat to the service caused by the PostgreSQL database engine vulnerability identified in the retired database version, Azure may choose to stop your database server to secure the service. In such case, you will be notified to upgrade the server before bringing the server online.

Citus and other extension versions

Depending on which version of PostgreSQL is running in a cluster, different versions of PostgreSQL extensions will be installed as well. In particular, PostgreSQL 14 and PostgreSQL 15 come with Citus 11, PostgreSQL versions 12 and 13 come with Citus 10, and earlier PostgreSQL versions come with Citus 9.5.

Next steps