2,073 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

Troubleshoot SkuNotAvailable in Azure Database for PostgreSQL Flexible Server

When provisioning a new PostgreSQL instance it failed. It's been over an hour and the failed instance hasn't cleared. I can't create a new instance with the same name because of this. The current blocker is InvalidResourceLocation, not…

Azure Database for PostgreSQL
asked 2026-10-10T02:26:35.83+00:00
rob 0 Reputation points
commented 2026-10-10T04:15:17.0733333+00:00
rob 0 Reputation points
1 answer

Azure Database for PostgreSQL flexible server: Diagnostic log export to Log Analytics stopped suddenly for all categories, server healthy, recreating settings and restart have no effect

Issue Diagnostic log export from an Azure Database for PostgreSQL flexible server (West Europe) to a Log Analytics workspace stopped abruptly on 24 Aug 2026 between 08:43–08:57 UTC. All five resource-specific tables ceased ingesting new records…

Azure Database for PostgreSQL
asked 2026-08-24T18:46:32.3066667+00:00
megamingus 0 Reputation points
edited a comment 2026-10-09T16:01:44.02+00:00
Povilas Poguda 0 Reputation points
2 answers

postgreSQL server is stuck in starting status

It has been stuck for hours now. Can not restart or stop using CLI because the server is still in starting status and command gets rejected. What is the fix for this?

Azure Database for PostgreSQL
asked 2026-09-23T17:27:41.3633333+00:00
Jesse B 0 Reputation points
edited an answer 2026-10-09T15:53:06.9066667+00:00
Alison A 5,320 Reputation points Microsoft External Staff Admin
1 answer

Azure Database for PostgreSQL: Regional provisioning restriction in East US — Support request to lift restriction

Problem description I am seeking assistance to lift the provisioning restriction for Azure Database for PostgreSQL flexible server in the East US region. My goal is to create a new PostgreSQL flexible server in East US using Azure CLI, but the…

Azure Database for PostgreSQL
asked 2026-10-03T04:27:59.1866667+00:00
Sree Hari Thiriveedhi 0 Reputation points
commented 2026-10-09T05:08:21.51+00:00
Andriy Bilous 12,436 Reputation points MVP
1 answer

Private PostgreSQL flexible server geo-backup networking and pre-deployment zone-HA capacity checks

We are evaluating a new private Azure Database for PostgreSQL flexible server in Central US: PostgreSQL 17, General Purpose Standard_D2ds_v5, Premium SSD 32 GiB, different-zone HA with same-zone fallback disabled, 35-day retention and geo-redundant…

Azure Database for PostgreSQL
asked 2026-10-09T04:02:09.2666667+00:00
Fabric Admin 0 Reputation points
edited an answer 2026-10-09T05:04:42.6033333+00:00
Andriy Bilous 12,436 Reputation points MVP
0 answers

Azure Database for PostgreSQL: Creation Failures in East US 2 Region — Capacity Restrictions

Problem description I am unable to create new Azure Database for PostgreSQL flexible servers in the East US 2 region since October 6, 2026. Despite a similar server successfully created on September 28, 2026, and SKU listings indicating availability, all…

Azure Database for PostgreSQL
asked 2026-10-08T13:45:43.62+00:00
Hunter-8548 0 Reputation points
0 answers

Azure for Students — PostgreSQL Flexible Server B1ms availability in East Asia

I'm using an enabled Azure for Students subscription in East Asia and preparing to deploy PostgreSQL Flexible Server 16 using the Burstable Standard_B1ms SKU with 32 GiB storage and private networking. Both Azure CLI list-skus and the REST capabilities…

Azure Database for PostgreSQL
asked 2026-10-08T12:15:01.6966667+00:00
Tubtub Alvin 0 Reputation points
1 answer

Azure Database for PostgreSQL: Auto-pause no respetando horarios establecidos — problema persistente

Descripción del problema Estoy enfrentando un problema con mi Azure SQL Database. La base de datos, que soporta auto-pause, no entra en modo de pausa en los horarios configurados, sino que permanece activa y genera cargos continuos incluso durante los…

Azure Database for PostgreSQL
asked 2026-09-09T16:44:29.9633333+00:00
Nicolas Falcon 0 Reputation points
edited an answer 2026-10-08T12:08:07.5+00:00
Smaran Thoomu 35,955 Reputation points Microsoft External Staff Moderator
1 answer

Azure Database for PostgreSQL Flexible Server: Region access — Issue with East US region restrictions

Problem description I'm trying to create a new Azure Database for PostgreSQL Flexible Server in the East US region using Azure CLI, but I encounter the error: "Provisioning is restricted in this region. Please choose a different region." I need…

Azure Database for PostgreSQL
asked 2026-10-08T10:57:29.9833333+00:00
Morgan-4512 0 Reputation points
answered 2026-10-08T11:21:51.08+00:00
Senthil kumar 2,585 Reputation points
1 answer

Flexible Server: Entra user with ismfa=true refused even though token amr contains "mfa"

On Azure Database for PostgreSQL Flexible Server (PostgreSQL 18, Burstable tier), an Entra user principal created with pgaadauth_create_principal('<user UPN>', false, true) is refused at login with: FATAL: The specified role must be authenticated…

Azure Database for PostgreSQL
asked 2026-10-08T04:16:15.93+00:00
Adam 0 Reputation points
answered 2026-10-08T10:31:31.3033333+00:00
Salamat Shah 830 Reputation points MVP
1 answer One of the answers was accepted by the question author.

Azure PostgreSQL FlexibleServer is stuck for days now after trying to scale up and cannot be recovered.

We created an Azure Database PostgreSQL Flexible Server and started with a burstable tier first to setup everything and do some tests before we decide to go live with the new features on production. Few days before going live we decided to scale up from…

Azure Database for PostgreSQL
asked 2026-09-25T11:49:30.02+00:00
Karol Marek 20 Reputation points
accepted 2026-10-08T10:02:32.21+00:00
Karol Marek 20 Reputation points
2 answers

Azure Database for PostgreSQL: Issue with Deletion Due to Active Replicas — Metadata Stale or Stuck Role?

Problem description I am attempting to delete an Azure Database for PostgreSQL flexible server (Citus) in West Europe, but the delete operation fails because the server reports that there are 2 active replicas, even though I believe the replica has…

Azure Database for PostgreSQL
asked 2026-10-07T19:42:23.1533333+00:00
GustavoHiga-5354 0 Reputation points
edited an answer 2026-10-08T03:15:04.77+00:00
Allan Solomon Mejia 10,385 Reputation points
1 answer

Azure Database for PostgreSQL flexible server stuck in UPDATE state — Cannot access or restart

Problem description I am experiencing an issue with my Azure Database for PostgreSQL flexible server, which has become unresponsive and is stuck in the 'Updating' state. I cannot access the server, and attempts to restart it have failed. No recent…

Azure Database for PostgreSQL
asked 2026-10-07T07:29:44.1966667+00:00
Sarel Coetzer 0 Reputation points
answered 2026-10-07T08:53:20.47+00:00
Salamat Shah 830 Reputation points MVP
1 answer

Azure Database for PostgreSQL flexible server: Point-in-time restore — Encountered failure during restore process

Problem description I am attempting to perform a point-in-time restore on my Azure Database for PostgreSQL flexible server, but the operation fails consistently. The restore was initiated via Azure CLI, specifying a restore point from September 28, 2026,…

Azure Database for PostgreSQL
asked 2026-09-29T23:36:08.2133333+00:00
GustavoHiga-5354 0 Reputation points
commented 2026-10-07T07:42:52.0766667+00:00
SIVASANKAR YEDDULA 250 Reputation points Microsoft External Staff Moderator
2 answers

Azure Resource Provider Registration Failing with InternalServerError — Subscription Registration Issue

Problem description I am unable to register the Microsoft.DBforPostgreSQL resource provider for my Azure subscription. Every attempt to register using the portal, Azure CLI, or ARM requests results in an InternalServerError. The registration has been…

Azure Database for PostgreSQL
asked 2026-09-19T08:59:26.16+00:00
RedwanHossain-0639 0 Reputation points
commented 2026-10-07T01:16:32.1+00:00
CSC-285 Jacksonville_NC 0 Reputation points
1 answer One of the answers was accepted by the question author.

pg_textsearch extension support on Azure Database for PostgreSQL

Are there any plans to add support for the pg_textsearch extension (https://github.com/timescale/pg_textsearch) to Azure Database for PostgreSQL? This extension offers advanced full-text search capabilities that would be highly beneficial for users who…

Azure Database for PostgreSQL
asked 2026-02-04T11:35:19.82+00:00
Miguel Silva 65 Reputation points
commented 2026-10-06T23:25:26.6533333+00:00
Roberto Duran 10 Reputation points
1 answer

Azure Database for PostgreSQL: Logical Replication Slot Synchronization Issue After HA Deployment

Problem description I am using Azure Database for PostgreSQL flexible server in the Central US region with PostgreSQL 16.15, configured for zone-redundant high availability. I have set up logical replication for a downstream CDC consumer using the…

Azure Database for PostgreSQL
asked 2026-09-28T18:33:36.85+00:00
Alex Kutner 0 Reputation points
commented 2026-10-06T21:38:50.0366667+00:00
Maraiah Kasetti (Wipro Limited) 85 Reputation points Microsoft External Staff Moderator
1 answer

Azure Database for PostgreSQL: Read replica restarted unexpectedly — no customer-initiated operation

Problem description I am concerned about the unexpected restarts of my Azure Database for PostgreSQL flexible server read replica that occurred twice on September 30, 2026, between 09:33 and 09:47 UTC, without any action from my team. After these…

Azure Database for PostgreSQL
asked 2026-09-30T19:51:56.28+00:00
VinceR-2832 0 Reputation points
answered 2026-10-06T12:40:09.6166667+00:00
Salamat Shah 830 Reputation points MVP
0 answers

Identify Azure-managed azuresu localhost client backend sessions on Azure Database for PostgreSQL Flexible Server

I am using Azure Database for PostgreSQL Flexible Server and need to identify Azure-managed privileged sessions visible in pg_stat_activity. The server is PostgreSQL 18.6. During read-only inspection, I observed sessions with: role: azuresu backend…

Azure Database for PostgreSQL
asked 2026-10-06T09:46:34.66+00:00
Phathutshedzo Nemandalali 0 Reputation points
0 answers

Azure PostgreSQL FlexibleServer is stuck for over a week now after trying to scale up and cannot be recovered.

We tried to scale up Azure PostgreSQL Flexible Server from Burstable tier (B1) to General Purpose tier (Intel, Standard_D4s_v3). The server got stuck in Updating state with a message to wait and if it's taking too long to contact Microsoft Support. We…

Azure Database for PostgreSQL
asked 2026-10-01T14:38:56.84+00:00
Karol Marek 20 Reputation points
commented 2026-10-02T09:23:32.3966667+00:00
Karol Marek 20 Reputation points