2,051 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 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-09-19T09:27:05.71+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
1 answer

PostgreSQL Flexible Server stuck in "Updating" state for hours after a compute scale (General Purpose → Burstable)

I scaled an Azure Database for PostgreSQL Flexible Server and it has been stuck in the "Updating" state for over 4 hours, with no sign of completing or failing. Operation performed: Changed the compute from General Purpose (Standard_D4ads_v5,…

Azure Database for PostgreSQL
asked 2026-09-08T14:34:04.25+00:00
Kriti Bhadada 5 Reputation points
commented 2026-09-18T12:03:11.1466667+00:00
Kvns Krishna Teja 0 Reputation points Microsoft External Staff Moderator
2 answers

Azure Database for PostgreSQL Flexible Server Stuck in Dropping State

We are experiencing an issue with our Azure Database for PostgreSQL Flexible Server. The server is currently showing the status “Dropping” in the Azure Portal and has not completed the deletion process. We tried from cli but it says dosent exist. From…

Azure Database for PostgreSQL
asked 2026-08-27T09:46:22.9633333+00:00
Sanchit Pandit 0 Reputation points
answered 2026-09-18T07:50:46.12+00:00
grace royal 0 Reputation points
1 answer

PostgreSQL 16 Flexible Server: How to remove automatic azuresu-granted creator role memberships?

We need guidance on a PostgreSQL 16 role-provisioning issue in a non-production Azure Database for PostgreSQL Flexible Server environment. Environment: Azure Database for PostgreSQL Flexible Server PostgreSQL 16 Customer administrator: bemtechadmin,…

Azure Database for PostgreSQL
asked 2026-09-16T14:40:04.4766667+00:00
Taufiq ALblooshi 0 Reputation points
commented 2026-09-17T18:39:07.2733333+00:00
Allan Solomon Mejia 9,000 Reputation points
1 answer

PostgreSQL Flexible Server (West Europe): PostgreSQLLogs stopped reaching Log Analytics on 2026-08-24 on two servers; restart and diagnostic setting recreation do not help

Two Azure Database for PostgreSQL Flexible Servers (PostgreSQL 18.4, West Europe, different subscriptions and different Log Analytics workspaces) stopped delivering the PostgreSQLLogs diagnostic category to Log Analytics on the same day, 2026-08-24,…

Azure Database for PostgreSQL
asked 2026-09-07T13:56:52.8166667+00:00
Hugo Lorenzo Mato 5 Reputation points
commented 2026-09-16T11:46:10.6966667+00:00
Kvns Krishna Teja 0 Reputation points Microsoft External Staff Moderator
0 answers

Azure Database for PostgreSQL flexible server: Subscription region restriction — Request for East US 2 regional access review

Problem description I am trying to provision an Azure Database for PostgreSQL flexible server in the East US 2 region to support my production SaaS application. During creation via the Azure portal, I receive the error message: "Subscription…

Azure Database for PostgreSQL
asked 2026-09-15T12:54:40.2433333+00:00
CourtneyC-7109 0 Reputation points
commented 2026-09-15T13:24:36.3566667+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
0 answers

PostgreSQL Flexible Server password reset ARM operation stuck at Started/Accepted — how to determine terminal state?

We issued an administrator-password-only PATCH against an Azure Database for PostgreSQL Flexible Server using API version 2024-08-01. Azure returned HTTP 202. Our client failed to retain the Azure-AsyncOperation / Location polling URL before exiting. The…

Azure Database for PostgreSQL
asked 2026-09-13T21:35:15.0766667+00:00
Stuart McAllister 5 Reputation points
commented 2026-09-14T15:47:00.35+00:00
Vinodh247-1375 44,716 Reputation points Volunteer Moderator
0 answers

PostgreSQL Flexible Server: pg_duckdb not on allowlist

According to this GitHub discussion, pg_duckdb was available on the PostgreSQL Flexible Server extensions for some time. During that time, I installed the extension. It is now not available anymore on the extensions allowlist, but it is installed in my…

Azure Database for PostgreSQL
asked 2026-07-30T11:17:24.6533333+00:00
Rens Oostenbach 40 Reputation points
commented 2026-09-14T13:59:31.9033333+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
0 answers

How to Allow Azure AD-Authenticated Users to Interact with PostgreSQL FDW Tables through User Mapping

I am using PostgreSQL Foreign Data Wrappers (FDW) in an Azure Database for PostgreSQL - Flexible Server environment. My users authenticate to the database using Azure AD token-based authentication. The issue arises when these users attempt to run UPDATE…

Azure Database for PostgreSQL
asked 2025-04-01T15:21:16.35+00:00
van der Stelt, Gideon 0 Reputation points
commented 2026-09-14T06:18:24.89+00:00
van der Stelt, Gideon 0 Reputation points
0 answers

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
commented 2026-09-09T17:49:38.81+00:00
Ganesh Chelluri 190 Reputation points Microsoft External Staff Moderator
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-09-09T07:43:56.1133333+00:00
Graczyk Damian 0 Reputation points
1 answer

Azure Database for PostgreSQL Flexible Server: Region-access request in East US never escalated to a human

I'm trying to understand if this is expected behavior for Azure support on region-access requests, because it doesn't match the documented 24-48h SLA. Context: A subscription of ours can't provision Azure Database for PostgreSQL Flexible Server in East…

Azure Database for PostgreSQL
asked 2026-09-04T20:00:04.6966667+00:00
Rafael Ferreira 0 Reputation points MVP
answered 2026-09-08T13:47:07.93+00:00
Rafael Ferreira 0 Reputation points MVP
1 answer

Azure Database for PostgreSQL Flexible Server Stuck in Dropping State after delete

Hello, I am experiencing an issue with an Azure Database for PostgreSQL Flexible Servers that are stuck in the "Dropping" state. The servers have been showing the "Dropping" status for approximately 20** **hours and the operation does…

Azure Database for PostgreSQL
asked 2026-09-03T07:55:37.77+00:00
Petko Stoyanov 0 Reputation points
commented 2026-09-05T13:03:42.97+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
1 answer

my postgres database takes 53 minutes starting up then fails to start

After several attempts my postgres database server will not start. Error codeResourceOperationFailure MessageThe resource operation completed with terminal provisioning state 'Failed'. what does that mean exactly and how can I get a ticket opened for…

Azure Database for PostgreSQL
asked 2026-08-11T14:19:49.1633333+00:00
Stephen Smalley 0 Reputation points
answered 2026-09-04T17:25:17.4233333+00:00
Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Unable to enable citus_columnar on Azure PostgreSQL Elastic Clusters

Hello, I am using Azure Database for PostgreSQL Flexible Server – Elastic Clusters (PostgreSQL 17 + Citus 13.2). According to the open-source Citus documentation and the previous Azure Cosmos DB for PostgreSQL (Hyperscale) service, columnar storage is a…

Azure Database for PostgreSQL
asked 2026-09-04T09:22:40.59+00:00
Adela M B 20 Reputation points
accepted 2026-09-04T13:01:39.49+00:00
Adela M B 20 Reputation points
1 answer

Azure PostgreSQL Flexible Server B1ms fails to provision in Belgium Central with InternalServerError

I am using an Azure for Students subscription and I cannot provision Azure Database for PostgreSQL Flexible Server in Belgium Central. Configuration: PostgreSQL 17 Standard_B1ms Burstable tier 32 GB storage High availability disabled I reproduced the…

Azure Database for PostgreSQL
asked 2026-08-28T14:15:04.9166667+00:00
RAFAEL AGUDO MARTIN 0 Reputation points
commented 2026-09-02T00:45:06.3966667+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
1 answer

In-place major version upgrade for Azure Database for PostgreSQL Elastic Clusters (v16 → v17)?

We're running Azure Database for PostgreSQL - Elastic Clusters at Postgres version 16. This cluster was created via the Azure-provided migration tool from Cosmos DB for PostgreSQL (now deprecated), which only supports migrating to v16. We now need to…

Azure Database for PostgreSQL
asked 2026-08-12T10:19:53.2033333+00:00
Aashay Thakkar 0 Reputation points
answered 2026-08-29T06:35:39.84+00:00
Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator
0 answers

Azure Flexible Server Postgresql -- Not responding or working after failed scale up.

My production Azure Database for PostgreSQL Flexible Server failed during a scale-up operation and is now completely frozen in an 'Unavailable (Unplanned)' state. Standard portal Stop/Restart actions are totally non-responsive due to a stuck backend…

Azure Database for PostgreSQL
asked 2026-08-24T20:34:19.25+00:00
rsbepvb 1 Reputation point
commented 2026-08-28T14:04:08.1666667+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
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
commented 2026-08-27T11:55:56.2933333+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
0 answers

Join: Microsoft Azure Q&A Champions Program

The Microsoft Azure Q&A Champions Program recognizes and empowers a global community of internal and external Azure experts who help customers succeed by providing high-quality, trusted answers on Microsoft Q&A. The program scales expert led…

Azure Database for PostgreSQL
asked 2026-05-26T00:01:27.6966667+00:00
Ashley Swearingen 0 Reputation points Microsoft External Staff Moderator
edited the question 2026-08-26T19:06:33.8466667+00:00
Ashley Swearingen 0 Reputation points Microsoft External Staff Moderator