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
- General Availability of oracle_fdw extension.
- General Availability of index tuning on Azure Database for PostgreSQL flexible server.
- General Availability of the Semantic Ranker Solution Accelerator for Azure Database for PostgreSQL flexible server.
- Public preview of age extension.
- Public preview of GraphRAG Solution Accelerator for Azure Database for PostgreSQL flexible server.
- Public preview of On-Demand Backups.
Release: November 2024
- General availability of High-Availability Health Status Monitoring for Azure Database for PostgreSQL - Flexible Server.
- PostgreSQL 12 will retire on November 14, 2024. Please upgrade to a supported version before retirement to ensure continued support and security.
Release: October 2024
- General Availability of Task Automation. ^
- Preview of Fabric Mirroring for Azure Database for PostgreSQL flexible server.
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
- General availability of Database Size Metrics for Azure Database for PostgreSQL flexible server.
- General availability: postgres_protobuf extension.
Release: July 2024
- General availability of Major Version Upgrade Support for PostgreSQL 16 for Azure Database for PostgreSQL flexible server.
- General availability of Pgvector 0.7.0 extension.
- General availability support for Storage-Autogrow with read replicas
- Support for SCRAM authentication authentication set as default for new PostgreSQL 14+ new server deployments.
- General availability support for System Assigned Managed Identity for Azure Database for PostgreSQL flexible server.
Release: June 2024
- Support for new minor versions 16.3, 15.7, 14.12, 13.15, and 12.19. $
- General availability of IOPS scaling on Azure Database for PostgreSQL flexible server.
- CMK support for LTR is in Public preview long-term backup retention.
- Support for built-in Azure Policy definitions
Release: May 2024
- General availability of Postgres azure_ai extension.
- Public preview of azure_local_ai extension.
- Public preview of index tuning on Azure Database for PostgreSQL flexible server.
- Public preview of Updating PostgreSQL extensions on Azure Database for PostgreSQL flexible server.
- Support for the following extensions:
Release: April 2024
- General availability of virtual endpoints and promote to primary server operation for read replicas.
- Support for new minor versions 16.2, 15.6, 14.11, 13.14, 12.18. $
- Support for new PgBouncer versions 1.22.1. $
Release: March 2024
- Public preview of Major Version Upgrade Support for PostgreSQL 16 for Azure Database for PostgreSQL flexible server.
- Public preview of real-time language translations with azure_ai extension on Azure Database for PostgreSQL flexible server.
- Public preview of real-time machine learning predictions with azure_ai extension on Azure Database for PostgreSQL flexible server.
- General availability of version 0.6.0 of vector extension on Azure Database for PostgreSQL flexible server.
- General availability of Migration service in Azure Database for PostgreSQL flexible server.
- Support for PostgreSQL 16 changes with BYPASSRLS
Release: February 2024
- Support for new minor versions 16.1, 15.5, 14.10, 13.13, 12.17, 11.22. $
- General availability of Major Version Upgrade logs
- General availability of private endpoints.
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
- Public preview of Server logs.
- General availability of TLS Version 1.3 support.
- General availability of Microsoft Defender support
Release: November 2023
- General availability of PostgreSQL 16 for Azure Database for PostgreSQL flexible server.
- General availability of near-zero downtime scaling.
- General availability of Pgvector 0.5.1 extension.
- General availability of Italy North region.
- Public preview of premium SSD v2.
- Public preview of decoupling storage and IOPS.
- Public preview of private endpoints.
- Public preview of virtual endpoints and new promote to primary server operation for read replica.
- Public preview of Postgres azure_ai extension.
- Public preview of pg_failover_slots extension.
- Public preview of long-term backup retention.
Release: October 2023
- Support for new minor versions 15.4, 14.9, 13.12, 12.16, 11.21. $
- General availability of Grafana Monitoring Dashboard for Azure Database for PostgreSQL flexible server.
Release: September 2023
- General availability of Storage autogrow for Azure Database for PostgreSQL flexible server.
- General availability of Cross Subscription and Cross Resource Group Restore for Azure Database for PostgreSQL flexible server.
Release: August 2023
- Support for minor versions 15.3, 14.8, 13.11, 12.15, 11.20. $
- General availability of Enhanced Metrics, Autovacuum Metrics, PgBouncer Metrics and Database availability metric for Azure Database for PostgreSQL flexible server.
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
- Support for minor versions 15.2 (preview), 14.7, 13.10, 12.14, 11.19. $
- General availability of Query Performance Insight for Azure Database for PostgreSQL flexible server.
- General availability of Major Version Upgrade for Azure Database for PostgreSQL flexible server.
- General availability of Restore a dropped server for Azure Database for PostgreSQL flexible server.
- Public preview of Storage auto-grow for Azure Database for PostgreSQL flexible server.
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
- Public preview of Query Performance Insight for Azure Database for PostgreSQL flexible server.
- Public preview of: Power BI integration for Azure Database for PostgreSQL flexible server.
- Public preview of Troubleshooting guides for Azure Database for PostgreSQL flexible server.
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
- Public preview of Autovacuum Metrics for Azure Database for PostgreSQL flexible server.
- Support for semver extension with new servers. $
- Public Preview of Major Version Upgrade for Azure Database for PostgreSQL flexible server.
- Support for Geo-redundant backup feature when using Data encryption with customer managed key.
- Support for minor versions 14.6, 13.9, 12.13, 11.18. $
Release: January 2023
- General availability of Microsoft Entra authentication support for Azure Database for PostgreSQL flexible server in all Azure Public Regions.
- 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 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
- Support for Read Replica feature in public preview.
- Support for Microsoft Entra authentication authentication in public preview.
- Support for Customer managed keys in public preview.
- Published Security and compliance certifications for Azure Database for PostgreSQL flexible server.
- Postgres 14 is now the default PostgreSQL version.
Release: September 2022
- Support for Fast Restore feature.
- General availability of Geo-Redundant Backups. See the regions where Geo-redundant backup is currently available.
Release: August 2022
- Support for PostgreSQL minor version 14.4. $
- 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.
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
- Support for new regions India West, Canada East.
Release: April 2022
- Support for latest PostgreSQL minors 13.6, 12.10 and 11.15 with new server creates. $
- Support for updating Private DNS Zone for Azure Database for PostgreSQL flexible server private networking for existing servers$.
$ 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
- Azure Database for PostgreSQL flexible server is Generally Available.
- Support for latest PostgreSQL minors 13.4, 12.8 and 11.13 with new server creates. $
- 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.
- Support for Azure Stream Analytics (ASA) connector in Preview to ingest high throughput streaming data to existing table.
- 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: 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 includingextra_float_digits
, andpgbouncer.query_wait_timeout
parameters. $ - Support for
pg_stat_reset_shared('bgwriter');
andpg_stat_reset_shared('archiver');
to reset the counters shown in thepg_stat_bgwriter
andpg_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
- Support for PostgreSQL major version 13.
- Support for the following extensions:
- 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 (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.
- Intelligent performance .
- 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. - 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:
- To contact Azure Support, file a ticket from the Azure portal.
- 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
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.