Release notes - Azure Database for PostgreSQL - Flexible Server
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 to Flexible Server - PostgreSQL
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 extension semver with new servers$
- Public Preview of Major Version Upgrade for Azure Database for PostgreSQL – Flexible Server.
- Support for Geo-redundant backup feature when using Disk Encryption with Customer Managed Key (CMK) feature.
- Support for minor versions 14.6, 13.9, 12.13, 11.18 $
Release: January 2023
- General availability of Azure Active Directory 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 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
- Support for Read Replica feature in public preview.
- Support for Azure Active Directory authentication in public preview.
- Support for Customer managed keys in public preview.
- Published Security and compliance certifications for 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 deployment option.
- Support for choosing standby availability zone when deploying zone-redundant high availability.
- Support for extensions PLV8, pgrouting with new servers$
- Version updates for extension PostGIS.
- General availability of Azure Database for PostgreSQL - Flexible Server in Canada East and Jio India West regions.
$ New servers get these features automatically. In your existing servers, these features are enabled during your server's future maintenance window.
Release: May 2022
- Support for new regions Jio 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. 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
- Azure Database for PostgreSQL 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. 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 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. 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 usingshared_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.
- Intelligent performance .
- Several bug fixes, stability and performance improvements.
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 isn't a technical support alias.
In addition, 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 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'll 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
Feedback
Submit and view feedback for