Supported database versions in Azure Cosmos DB for PostgreSQL
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.3. 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.8. 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.11. 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.15. 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.20. 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
Azure Cosmos DB for PostgreSQL supports each major version of PostgreSQL from the date on which Azure begins supporting the version until the PostgreSQL community retires that major PostgreSQL version. Refer to PostgreSQL community versioning policy.
Azure Cosmos DB for PostgreSQL automatically performs minor version updates to the latest PostgreSQL version available on Azure 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 13, PostgreSQL 14, and PostgreSQL 15 come with Citus 11, PostgreSQL 12 comes with Citus 10, and earlier PostgreSQL versions come with Citus 9.5.
Next steps
- See which extensions are installed in which versions.
- Learn to create a cluster.
Feedback
Submit and view feedback for