Edit

Release notes - Azure Database for PostgreSQL - Flexible Server

  • Article
  • 7 minutes to read

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

This page provides latest news and updates regarding feature additions, engine versions support, extensions, and any other announcements relevant for Flexible Server - PostgreSQL

Release: March 2023

Release: February 2023

Release: January 2023

Release: December 2022

  • Support for extensions pg_hint_plan 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 will be 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

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

Release: May 2022

Release: April 2022

$ New servers get these features automatically. In your existing servers, these features are enabled 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 extensions TimescaleDB, orafce, and pg_repack with new servers$
  • Extensions need to be allow-listed 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. In your existing servers, these features are enabled during your server's future maintenance window.

Release: November 2021

$ New servers get these features automatically. In your existing servers, these features are enabled 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.
  • Server parameters page in Azure portal shows 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 non-SSL mode of connectivity using a new require_secure_transport server parameter.
  • Support for log_line_prefix server parameter, which adds the string at the beginning of each log line.
  • Support for Azure Resource Health for 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 v2.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. In your existing servers, these features are enabled 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 to be preloaded using shared_preload_libraries with new server creates$.
  • Support for lo extension. See the extensions page for versions supported with each major version $.
  • 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

  • Support for PostgreSQL major version 13.
  • Support for extensions including pg_partman, pg_cron, and pgaudit. See the extensions page for versions supported with each major version.
  • Several bug fixes, stability, and performance improvements.

Release: April 2021

  • Support for latest PostgreSQL minors 12.6 and 11.11 with new server creates.
  • Support for Virtual Network (VNET) 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 to connect to the Flexible server using Azure CLI with the az postgres flexible- server connect command.
  • Support for new regions.
  • Several portal improvements, including display of minor versions, summary of metrics on the overview blade.
  • Several bug fixes, stability, and performance improvements.

Contacts

For any questions or suggestions you might have on Azure Database for PostgreSQL flexible server, send an email to the Azure Database for PostgreSQL Team (@Ask Azure DB for PostgreSQL). Please note that this email address is not a technical support alias.

In addition, consider the following points of contact as appropriate:

Frequently Asked Questions

Will Flexible Server replace Single Server or Will Single Server be retired soon?

We continue to support Single Server and encourage you to adopt 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 will receive advance notice including a migration or transition path. Learn more about Microsoft Lifecycle policies here.

Next steps

Now that you've read an introduction to Azure Database for PostgreSQL flexible server deployment mode, you're ready to create your first server: Create an Azure Database for PostgreSQL - Flexible Server using Azure portal