Product updates for Azure Cosmos DB for PostgreSQL

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

Release notes

Azure Cosmos DB for PostgreSQL gets updated regularly.

Updates that don’t directly affect the internals of a cluster are rolled out gradually to all supported regions. Once such an update is rolled out to a region, it's available immediately on all new and existing Azure Cosmos DB for PostgreSQL clusters in that region.

Updates that change cluster internals, such as installing a new minor PostgreSQL version, are delivered to existing clusters as part of the next scheduled maintenance event. Such updates are available immediately to newly created clusters.

November 2024

• Retirement: As of November 21, 2024, PostgreSQL 12 is unsupported by PostgreSQL community.
  • See PostgreSQL community versioning policy.
  • See restrictions that apply to the retired PostgreSQL major versions in Azure Cosmos DB for PostgreSQL.

July 2024

• MD5 hashing is disabled in Azure Cosmos DB for PostgreSQL.

May 2024

• General availability: The latest minor PostgreSQL version updates (12.19, 13.15, 14.12, 15.7, and 16.3) are now available.
  • The last update for PostgreSQL 11 was released by community in November 2023.

March 2024

• General availability: Oracle's compatibility functions and packages enablement via orafce extension.

February 2024

• General availability: The latest minor PostgreSQL version updates (12.18, 13.14, 14.11, 15.6, and 16.2) are now available.
  • The last update for PostgreSQL 11 was released by community in November 2023.
• General availability: Microsoft Entra authentication is now supported in addition to Postgres roles in all supported regions.

January 2024

• General availability: 32 TiB storage per node for multi-node configurations in all supported regions.
  • See how to get the most out of storage
• General availability: Geo-redundant backup and restore
  • Learn more about backup and restore Azure Cosmos DB for PostgreSQL

December 2023

• Preview: PgBouncer is now supported with Microsoft Entra ID authentication.
• General availability: Azure Cosmos DB for PostgreSQL is now available in Poland Central and South India.
  • See all supported regions.

November 2023

• General availability: Availability zone (AZ) outage resiliency is now supported in select regions
• General availability: The latest minor PostgreSQL version updates (11.22, 12.17, 13.13, 14.10, 15.5, and 16.1) are now available in all supported regions.
• PostgreSQL 16 is now the default Postgres version for Azure Cosmos DB for PostgreSQL in Azure portal.
  • Learn how to do in-place upgrade of major PostgreSQL versions in Azure Cosmos DB for PostgreSQL.
• Retirement: As of November 9, 2023, PostgreSQL 11 is unsupported by PostgreSQL community.
  • See PostgreSQL community versioning policy.
  • See restrictions that apply to the retired PostgreSQL major versions in Azure Cosmos DB for PostgreSQL.

October 2023

• General availability: Azure SDKs are now generally available for all Azure Cosmos DB for PostgreSQL management operations supported in REST APIs.
  • .NET SDK
  • Go SDK
  • Java SDK
  • JavaScript SDK
  • Python SDK
• General availability: Azure CLI is now available for all Azure Cosmos DB for PostgreSQL management operations supported in REST APIs.
  • See details.
• General availability: Audit logging of database activities in Azure Cosmos DB for PostgreSQL is available through the PostgreSQL pgAudit extension.
  • See details.

September 2023

• General availability: PostgreSQL 16 support.
  • See all supported PostgreSQL versions here.
  • Upgrade to PostgreSQL 16
• General availability: Citus 12.1 with new features and PostgreSQL 16 support.
• General availability: Data encryption at rest using Customer Managed Keys (CMK) is now supported for all available regions.
  • See this guide for the steps to enable data encryption using customer managed keys.
• Preview: Geo-redundant backup and restore
  • Learn more about backup and restore Azure Cosmos DB for PostgreSQL
• Preview: 32 TiB storage per node for multi-node configurations is now available in all supported regions.
  • See how to maximize IOPS on your cluster.
• General availability: Azure Cosmos DB for PostgreSQL is now available in Australia Central, Canada East, and Qatar Central.
  • See all supported regions.

August 2023

• General availability: The latest minor PostgreSQL version updates (11.21, 12.16, 13.12, 14.9, and 15.4) are now available in all supported regions.
• General availability: PgBouncer version 1.20 is now supported for all PostgreSQL versions in all supported regions
  • See Connection pooling and managed PgBouncer in Azure Cosmos DB for PostgreSQL.
• General availability: Citus 12 is now available in all supported regions with PostgreSQL 14 and PostgreSQL 15.
  • Check what's new in Citus 12.
  • See Postgres and Citus version in-place upgrade.
• Preview: Microsoft Entra authentication is now supported in addition to Postgres roles.
• Preview: Azure CLI is now supported for all Azure Cosmos DB for PostgreSQL management operations.
  • See details.

July 2023

• Preview: Azure SDKs are now available for all Azure Cosmos DB for PostgreSQL management operations.
  • .NET (preview)
  • Go (preview)
  • Java (preview)
  • JavaScript (preview)
  • Python (preview)
• General availability: Terraform support is now available for all cluster management operations. See the following pages for details:
  • Cluster management
  • Worker node configuration
  • Coordinator / single node configuration
  • Postgres role management
  • Public access: Firewall rule management
  • Private access: Private endpoint management
  • Private access: Private Link service management
• General availability: 99.99% monthly availability Service Level Agreement (SLA).

June 2023

• General availability: Customer-defined database name is now available in all regions at cluster provisioning time.
  • If the database name isn't specified, the default citus name is used.
• General availability: Managed PgBouncer settings are now configurable on all clusters.
  • Learn more about connection pooling.
• General availability: Preferred availability zone (AZ) selection is now enabled in all Azure Cosmos DB for PostgreSQL regions that support AZs.
  • Learn about cluster node availability zones and how to set preferred availability zone.
• General availability: The new domain name and FQDN format for cluster nodes. The change applies to newly provisioned clusters only.
  • See details.
• Preview: Audit logging of database activities in Azure Cosmos DB for PostgreSQL is available through the PostgreSQL pgAudit extension.
  • See details.

May 2023

• General availability: Pgvector extension enabling vector storage is now fully supported on Azure Cosmos DB for Postgres.
• General availability: The latest minor PostgreSQL version updates (11.20, 12.15, 13.11, 14.8, and 15.3) are now available in all supported regions.
• General availability: Citus 11.3 is now supported on PostgreSQL 13, 14, and 15.
  • See this page for information on PostgreSQL and Citus version in-place upgrade.
• General availability: PgBouncer version 1.19.0 is now supported for all PostgreSQL versions in all supported regions
• General availability: Clusters are now always provisioned with the latest Citus version supported for selected PostgreSQL version.
  • See this page for the latest supported Citus versions.
  • See this page for information on PostgreSQL and Citus version in-place upgrade.

April 2023

• General availability: Representational State Transfer (REST) APIs are now fully supported for all cluster management operations.
• General availability: Bicep and ARM templates for Azure Cosmos DB for PostgreSQL's serverGroupsv2 resource type.
• Public preview: Data Encryption at rest using Customer Managed Keys is now supported for all available regions.
  • See this guide for the steps to enable data encryption using customer managed keys.

March 2023

• General availability: Cluster compute start / stop functionality is now supported across all configurations.

February 2023

• General availability: 4 TiB, 8 TiB, and 16 TiB storage per node is now supported for multi-node configurations in addition to previously supported 0.5 TiB, 1 TiB, and 2 TiB storage sizes.
  • See cost details for your region in 'Multi-node' section of the Azure Cosmos DB for PostgreSQL pricing page.
• General availability: The latest minor PostgreSQL version updates (11.19, 12.14, 13.10, 14.7, and 15.2) are now available in all supported regions.

January 2023

• General availability: 1- and 2-vCore burstable compute options for single-node clusters (for dev/test and smaller workloads).
  • Available in all supported regions. See compute and storage details here.

December 2022

• General availability: Azure Cosmos DB for PostgreSQL is now available in the Sweden Central and Switzerland West regions.
  • See full list of supported Azure regions.
• PostgreSQL 15 is now the default Postgres version for Azure Cosmos DB for PostgreSQL in Azure portal.
  • See all supported PostgreSQL versions.
  • See this guidance for the steps to upgrade your Azure Cosmos DB for PostgreSQL cluster to PostgreSQL 15.

November 2022

• General availability: Cross-region cluster read replicas for improved read scalability and cross-region disaster recovery (DR).
• General availability: Latest minor PostgreSQL version updates (11.18, 12.13, 13.9, 14.6, and 15.1) are now available in all supported regions.

October 2022

• General availability: Azure Cosmos DB for PostgreSQL, formerly known as Hyperscale (Citus), is now generally available.
  • See all previous product updates under the Hyperscale (Citus) name here.
• General availability: PostgreSQL 15 support.
  • See all supported PostgreSQL versions here.
  • Upgrade to PostgreSQL 15
• General availability: Citus 11.1 with new features and PostgreSQL 15 in Citus.
• Free trial: Now Azure Cosmos DB for PostgreSQL is a part of the Azure Cosmos DB 30-day free trial.
• Preview: Product Quick start in Azure portal with hands-on tutorials and embedded psql shell.

Features in preview

Azure Cosmos DB for PostgreSQL offers previews for unreleased features. Preview versions are provided without a service level agreement, and aren't recommended for production workloads. Certain features might not be supported or might have capabilities with limitations. For more information, see Supplemental Terms of Use for Microsoft Azure Previews

• There are no features in preview at this time.

Contact us

Let us know about your experience using preview features or if you have other product feedback, by emailing Ask Azure Cosmos DB for PostgreSQL. (This email address isn't a technical support channel. For technical problems, open a support request.)