Release notes - Azure Database for PostgreSQL - Flexible Server

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This article highlights the latest updates and enhancements for Azure Database for PostgreSQL - Flexible Server, service including new feature releases, supported engine versions, available extensions, and other important announcements.

Release: January 2025

  • Public preview of Elastic Clusters for Azure Database for PostgreSQL flexible server.

Release: December 2024

Release: November 2024

Release: October 2024

Release: September 2024

  • Public preview of PostgreSQL 17 for Azure Database for PostgreSQL flexible server. ^
  • Support for new minor versions 16.4, 15.8, 14.13, 13.16, and 12.20. $
  • Support for Reserved pricing for Intel and AMD V5 Skus for Azure Database for PostgreSQL flexible server.
  • Public preview of postgresql_anonymizer (anon) extension.
  • Support for MD5 is disabled in favor of SCRAM authentication authentication for new PostgreSQL 14+ new server deployments.
  • Collation sort order might change due to an underlying glibc update from 2.27 to 2.35. See PostgreSQL Wiki for details.

Release: Aug 2024

Release: July 2024

Release: June 2024

Release: May 2024

Release: April 2024

Release: March 2024

Release: February 2024

Release: January 2024

  • General availability of Server logs, including Portal and CLI support.
  • General availability of UAE Central region.
  • General availability of Israel Central region.
  • Worldwide public preview of long-term backup retention.

Release: December 2023

Release: November 2023

Release: October 2023

Release: September 2023

Release: August 2023

Release: July 2023

  • General Availability of PostgreSQL 15 for Azure Database for PostgreSQL flexible server.
  • Public preview of Automation Tasks for Azure Database for PostgreSQL flexible server.

Release: June 2023

Release: May 2023

  • Public preview of Database availability metric for Azure Database for PostgreSQL flexible server.
  • PostgreSQL 15 is now available in public preview for Azure Database for PostgreSQL flexible server in limited regions (West Europe, East US, West US2, South East Asia, UK South, North Europe, Japan East).
  • General availability: Pgvector extension for Azure Database for PostgreSQL - Flexible Server.
  • General availability: Azure Key Vault Managed HSM with Azure Database for PostgreSQL flexible server.
  • General availability 32 TB Storage with Azure Database for PostgreSQL flexible server.
  • Support for Ddsv5 and Edsv5 SKUs with Azure Database for PostgreSQL flexible server.

Release: April 2023

Release: March 2023

  • General availability of Read Replica for Azure Database for PostgreSQL flexible server.
  • Public preview of PgBouncer Metrics for Azure Database for PostgreSQL flexible server.
  • General availability of Azure Monitor workbooks for Azure Database for PostgreSQL flexible server.

Release: February 2023

Release: January 2023

Release: December 2022

  • Support for pg_hint_plan extension with new servers. $
  • General availability of Customer Managed Key feature with Azure Database for PostgreSQL flexible server in Canada East, Canada Central, Southeast Asia, Switzerland North, Switzerland West, Brazil South and East Asia Azure regions.

Release: November 2022

  • Public preview of Enhanced Metrics for Azure Database for PostgreSQL flexible server.
  • Support for minor versions 14.5, 13.8, 12.12, 11.17. $
  • General availability of Azure Database for PostgreSQL flexible server in China North 3 & China East 3 Regions.

Release: October 2022

Release: September 2022

Release: August 2022

$ New PostgreSQL 14 servers are provisioned with version 14.4. Your existing PostgreSQL 14.3 servers will be upgraded to 14.4 in your server's future maintenance window.

Release: July 2022

  • Support for Geo-redundant backup in more regions - Australia East, Australia Southeast, Canada Central, Canada East, UK South, UK West, East US, West US, East Asia, Southeast Asia, North Central US, South Central US, and France Central.

Release: June 2022

  • Support for PostgreSQL version 14.
  • Support for minor versions 14.3, 13.7, 12.11, 11.16. $
  • Support for [Same-zone high availability]/azure/reliability/reliability-postgresql-flexible-server deployment option.
  • Support for choosing standby availability zone when deploying zone-redundant high availability.
  • Support for plv8 extension with new servers. $
  • Support for pgrouting extension with new servers. $
  • Version updates for PostGIS extension.
  • General availability of Azure Database for PostgreSQL flexible server in Canada East and India West regions.

$ New servers get these features automatically. These features are enabled on your existing servers during your server's future maintenance window.

Release: May 2022

Release: April 2022

$ New servers get these features automatically. These features are enabled on your existing servers during your server's future maintenance window.

Release: February 2022

  • Support for latest PostgreSQL minors 13.5, 12.9 and 11.14 with new server creates. $
  • Support for US Gov regions - Arizona and Virginia.
  • Support for the following extensions with new servers: $
  • Extensions need to be allowlisted before they can be installed.
  • Support for zone redundant high availability for new server creates in regions Central India, Korea Central, East Asia, and West US 3.
  • Several bug fixes, stability, security, and performance improvements. $

$ New servers get these features automatically. These features are enabled on your existing servers during your server's future maintenance window.

Release: November 2021

$ New servers get these features automatically. These features are enabled on your existing servers during your server's future maintenance window.

Release: October 2021

  • Support for Ddsv4 and Edsv4 SKUs.
  • Ability to choose local disk for temporary tablespace using azure.enable_temp_tablespaces_on_local_ssd server parameter. The server parameters page in the Azure portal shows a unit of measurement and the PostgreSQL doc link for most parameters.
  • Several bug fixes, stability, and performance improvements.

Release: September 2021

  • Support for Terraform.
  • Support for new regions Central India and Japan West.
  • Support for a non-SSL mode of connectivity using a new require_secure_transport server parameter.
  • Support for the log_line_prefix server parameter, which adds the string at the beginning of each log line.
  • Support for Azure Resource Health for Azure Database for PostgreSQL flexible server health diagnosis and to get support.
  • Several bug fixes, stability, and performance improvements.

Release: July 2021

  • Support for new regions East Asia, Germany West Central, Korea South, South Central US, UK West.
  • Support for pglogical extension (2.3.2) with PostgreSQL 11, 12 and 13. $
  • PgBouncer now includes ignore_startup_parameters to ignore certain client-side driver's parameters including extra_float_digits, and pgbouncer.query_wait_timeout parameters. $
  • Support for pg_stat_reset_shared('bgwriter'); and pg_stat_reset_shared('archiver'); to reset the counters shown in the pg_stat_bgwriter and pg_stat_archiver views. $
  • Several bug fixes, stability, and performance improvements. $

$ New servers get these features automatically. These features are enabled on your existing servers during your server's future maintenance window.

Release: June 2021

  • Support for latest PostgreSQL minors 13.3, 12.7 and 11.12 with new server creates. $
  • Support for new regions, including Australia Southeast, Brazil South, Korea Central, Norway East, South Africa North, Switzerland North, UAE North, and West US.
  • Support for on-demand failover capabilities including forced failover and planned failover for zone redundant high availability deployments.
  • Support for SCRAM authentication for all major versions with new server creates. $
  • Support for pg_prewarm extension to be preloaded using shared_preload_libraries with new server creates. $
  • Support for lo extension. $
  • Several bug fixes, stability, and performance improvements. $

$ New servers get these features automatically. Your existing servers will be automatically upgraded to the latest supported minor version and also new features are enabled during your server's future maintenance window.

Release: May 2021

Release: April 2021

  • Support for latest PostgreSQL minors 12.6 and 11.11 with new server creates.
  • Support for Virtual Network (virtual network) private DNS zone.
  • Support to choose the Availability zone during Point-in-time recovery operation.
  • Support for new regions, including Australia East, Canada Central, and France Central.
  • Support for built-in PgBouncer connection pooler.

Release: October 2020 - March 2021

  • Improved experience connecting connect to the Azure Database for PostgreSQL flexible server instance using Azure CLI with the az postgres flexible- server connect command.
  • Support for new regions.
  • Several portal improvements, including the display of minor versions and summary of metrics on the overview page.
  • Several bug fixes, stability, and performance improvements.

Contacts

For any questions or suggestions you might have on Azure Database for PostgreSQL flexible server, consider the following points of contact as appropriate:

Frequently Asked Questions

Will the Azure Database for PostgreSQL flexible server replace the Azure Database for PostgreSQL single server, or Will it soon be retired?

Yes.

However, we'll continue to support Azure Database for PostgreSQL single server until March 28, 2025, and encourage you to adopt Azure Database for PostgreSQL flexible server, which has richer capabilities such as zone resilient HA, predictable performance, maximum control, custom maintenance window, cost optimization controls, and simplified developer experience suitable for your enterprise workloads. If we decide to retire any service, feature, API, or SKU, you'll receive advance notice, including a migration or transition path. Learn more about Microsoft Lifecycle policies here.