APPLIES TO:
Azure Database for PostgreSQL - Flexible Server
The following section describes capacity and functional limits in elastic clusters with Azure Database for PostgreSQL.
Current limitation of Azure Database for PostgreSQL Flexible server also apply to elastic clusters. The rest of the document describes differences that apply only to elastic clusters.
General
In what regions can I use elastic clusters?
Elastic clusters are an Azure Database for PostgreSQL flexible server feature and as such are available in the same regions.
Elastic clusters aren't available in the region I need, what can I do?
We're enabling other regions shortly, if you're interested in specific regions fill out this form.
Can I create more databases in an elastic cluster?
The Azure portal provides credentials to connect to exactly one database per cluster. Currently, creating another database isn't allowed, and the CREATE DATABASE
command fails with an error.
This database is called postgres
by default. After the public preview, custom database names at cluster provisioning time will be supported.
What PostgreSQL version is supported with elastic clusters?
Elastic clusters support PostgreSQL version 16 during the public preview.
Can I use Major Version Upgrades with elastic clusters?
Currently, Major Version Upgrades aren't supported during the preview.
Can I download server logs?
Currently, downloading server logs isn't supported during the preview. You can use Azure Metrics, Log Analytic Workspaces and PostgreSQL views to analyze cluster behavior.
Can I use terraform to deploy elastic clusters?
Currently, terraform isn't supported during the preview. ARM templates are supported.
Backups
Can I use GEO backups & GEO restore?
Currently, GEO backups & GEO restore aren't supported during the preview.
Is Long Term Retention (LTR) supported?
Currently, Long Term Retention isn't supported during the preview.
Extensions
Why is TimescaleDB not available with elastic clusters?
TimescaleDB extension isn't supported on elastic cluster due to low-level conflicts with the Citus extension.
What extensions aren't supported during preview?
The following extensions aren't supported during the preview:
- anon
- pg_qs - Query Store
- postgis_topology
- TimescaleDB
Migrations
How can I migrate to/from elastic clusters?
Currently, migrations to/from elastic clusters can be done with pg_dump, pg_restore, and pgcopydb. Any other tool working with standard PostgreSQL should work.
Networking
Can I use PgBouncer for connection pooling with elastic clusters?
Connection pooling with PgBouncer is only available for the non-load-balanced connection port 5432. When PgBouncer is enabled, the pooling on port 6432 directs to port 5432
Can I use virtual network (VNet) with elastic clusters?
Currently, virtual network isn't supported during the preview.
Are Private Domain Name System (DNS) Zones supported with elastic clusters?
Currently, Private DNS Zones aren't supported during the preview.
Storage
Can I use customer-managed keys (CMK) for storage encryption?
Currently, customer-managed keys aren't supported during the preview.
Is Storage Auto Scale available?
Currently, Storage Auto Scale isn't supported during the preview.
Authentication
Can I use Microsoft Entra ID authentication with elastic clusters?
Currently, Microsoft Entra ID authentication isn't supported during the preview.
Performance
Can I use Query Performance Insights with elastic clusters?
Currently, Query Performance Insights isn't supported during the preview.
Can I use Automatic Index Tuning with elastic clusters?
Currently, Automatic Index Tuning isn't supported during the preview.
Can I use replicas with elastic clusters?
Currently, replicas aren't supported during the preview.