Migrate to Innovate Summit:
Learn how migrating and modernizing to Azure can boost your business's performance, resilience, and security, enabling you to fully embrace AI.Register now
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Release notes - Azure Database for PostgreSQL - Flexible Server
Article
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: February 2025
Support for new minor versions 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22. $
Support for pg_signal_autovacuum_worker role in PostgreSQL versions 15 and higher 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 of Customer Managed Key feature with Azure Database for PostgreSQL flexible server in all Azure public regions.
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 new regions Qatar Central, Switzerland West, France South.
$ 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.
Support for Geo-redundant backup and restore feature in preview in selected paired regions - East US 2, Central US, North Europe, West Europe, Japan East, and Japan West.
Support for new regions North Central US, Sweden Central, and West US 3.
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.
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.
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.
Several bug fixes, stability, and performance improvements.
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.
Several portal improvements, including the display of minor versions and summary of metrics on the overview page.
Several bug fixes, stability, and performance improvements.
Important
$ - 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.
Contacts
For any questions or suggestions you might have on Azure Database for PostgreSQL flexible server, consider the following points of contact as appropriate:
To fix an issue with your account, file a support request in the Azure portal.
To provide feedback or to request new features, create an entry via UserVoice.
Frequently Asked Questions
Q. Will the Azure Database for PostgreSQL flexible server replace the Azure Database for PostgreSQL single server, or Will it soon be retired?
A. 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.
Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you're introduced to the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn abou
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Azure Database for PostgreSQL - Flexible Server