2,056 questions with Azure Database for PostgreSQL tags

Sort by: Updated
0 answers

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
1 answer

Data of type AzureDiagnostics is being dropped due to incorrect format at lineOffset: 247. Exception message: Unexpected character encountered while parsing value: \. Path 'records[247].resultDescription', line 1, position 155215.

The Diag setting of my Postgresql seems to send wrong data to my log analytics workspace: https://learn.microsoft.com/en-us/answers/questions/1701891/log-analytics-workspace-reports-10-warnings Data of type AzureDiagnostics is being dropped…

Azure Database for PostgreSQL
asked 2025-02-26T10:37:01.24+00:00
merlingadz 0 Reputation points
commented 2026-09-28T11:55:51.7533333+00:00
Toivo Voll 6 Reputation points
1 answer

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
answered 2026-09-27T13:48:19.48+00:00
Taz 9,936 Reputation points MVP Volunteer Moderator
1 answer

Website not Connecting to Database after Subscription Upgrade to Pay as you Go

My Database cannot be reached after my credit for the 1st time subscription expired. i upgraded to Pay as you go, all resource group are active but my website cannot still connect to the database. Any thoughts on what else i need to do. i use Postgres

Azure Database for PostgreSQL
asked 2026-09-25T17:20:57.74+00:00
Eniola Adeyemi 0 Reputation points
edited the question 2026-09-25T20:31:52.32+00:00
Erland Sommarskog 137.5K Reputation points MVP Volunteer Moderator
1 answer

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 0 Reputation points
commented 2026-09-25T13:08:42.42+00:00
Karol Marek 0 Reputation points
1 answer

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
answered 2026-09-22T16:08:22.73+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
1 answer

Azure Database for PostgreSQL Flexible Server uses huge amounts of space for backups

I have a problem very similar to that described in https://learn.microsoft.com/en-us/answers/questions/5838468/azure-postgresql-flexible-server-backup-storage-gr and this appears to be some sort of error with the Azure Database for PostgreSQL Flexible…

Azure Database for PostgreSQL
asked 2026-09-21T19:10:50.48+00:00
Geoffrey Thomas 0 Reputation points
commented 2026-09-21T21:32:39.4233333+00:00
Allan Solomon Mejia 9,735 Reputation points
1 answer

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
answered 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,735 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

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,801 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.5K 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 195 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