1,427 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

Azure Database for PostgreSQL flexible server stuck in stopping state - need assistance recovering

The Azure Database for PostgreSQL flexible server in our production environment has been down for over 20 hours. No connection can be made, whether through the Azure Portal, via pgAdmin4, or through the application. There was a critical health event…

Azure Database for PostgreSQL
asked 2025-06-20T05:32:16.76+00:00
Lachlan 30 Reputation points
answered 2025-06-20T12:47:37.3333333+00:00
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator
0 answers

PostgrSQL Flexible server stacked in Dropping state

Hello Azure Support Team and Community, I am an Azure Free Tier user experiencing a critical issue with an Azure PostgreSQL Flexible Server instance that is stuck in a 'Failed' provisioning state, preventing its deletion and the deletion of its…

Azure Database for PostgreSQL
asked 2025-06-20T00:42:57.6966667+00:00
Kov Bodia 0 Reputation points
commented 2025-06-20T08:42:36+00:00
Vijayalaxmi Kattimani 3,250 Reputation points Microsoft External Staff Moderator
0 answers

Workloads failing on Azure Postgres flexible server.

Workloads that are newly started on our database are failing with the error: "ERROR: Only members of "azure_pg_admin" are allowed to use CREATE EXTENSION [Failed SQL: (0) CREATE EXTENSION IF NOT EXISTS "uuid-ossp"". This was…

Azure Database for PostgreSQL
asked 2025-03-26T14:53:06.3433333+00:00
Julian Jarminowski 30 Reputation points
commented 2025-06-20T05:43:53.37+00:00
ianso 0 Reputation points
0 answers

PostgreSQL flexible server resource destroying trouble.

I was destroying infrastructure with terraform and it take to much time to destroy postgres db so i interrupted destroying process and did it manually via portal

Azure Database for PostgreSQL
asked 2025-06-19T22:01:26.7466667+00:00
Kov Bodia 0 Reputation points
commented 2025-06-19T22:13:43.6333333+00:00
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator
2 answers

Unable to Create Azure Database for PostgreSQL Flexible Server in Germany West Region

Attempting to migrate an Azure Database for PostgreSQL Single Server to a Flexible Server as outlined in the migration tutorial. The first step is to create the new Flexible Server using the same configuration as the existing single server. However, when…

Azure Database for PostgreSQL
asked 2025-03-06T15:11:45.9566667+00:00
Sarah Langheinrich 5 Reputation points
edited the question 2025-06-19T16:58:19.08+00:00
Akanksha Srivastava 0 Reputation points Microsoft Employee Admin
0 answers

Postgres server went down due to 'platform issue', attempted point in time restore but it's still going an hour later!?

My postgres server went down for unknown 'platform' reasons, nothing I did on my end. I tried a point in time restore to about an hour before it went down and it has been in the 'Running' state under 'Provsioniong' for an hour now. How to fix and restore…

Azure Database for PostgreSQL
asked 2025-06-13T15:16:38.33+00:00
meds 0 Reputation points
commented 2025-06-18T14:11:07.9433333+00:00
PratikLad 1,825 Reputation points Microsoft External Staff Moderator
1 answer

How to revive dropped Azure PostgreSQL flexible server with databases and data?

Testing some backup/recovery scenarios for my deployment. One of them would be accidentally destroying an environment via terraform destroy, including a flexible server for PostgreSQL with relevant data running in there. Now, according to Azure's…

Azure Database for PostgreSQL
asked 2025-06-12T06:39:39.6633333+00:00
nico 20 Reputation points
commented 2025-06-18T09:23:34.1733333+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer

"High Availability and Failover Configuration in PostgreSQL Flexible Server"

How can I configure automatic failover and high availability in Azure Database for PostgreSQL Flexible Server, and what are the recovery time objectives (RTO) in case of a zone failure?"

Azure Database for PostgreSQL
asked 2025-06-16T16:50:13.0233333+00:00
Priyanka Mamidiyala 0 Reputation points
commented 2025-06-17T17:46:30.4933333+00:00
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Query completes on Azure PostgreSQL but client keeps running (state = idle in transaction / ClientRead)

Environment Service: Azure Database for PostgreSQL – Flexible Server (General Purpose, D2ds_v5, 2 vCores, 8 GiB RAM, 1024 GiB storage) Client OS: Windows 11 / WSL 2 PostgreSQL version: 15.12 Problem I connect from PyCharm and run fairly simple DDL /…

Azure Database for PostgreSQL
asked 2025-06-11T09:34:33.4833333+00:00
Anna 20 Reputation points
accepted 2025-06-17T11:10:42.28+00:00
Anna 20 Reputation points
1 answer

I am trying to scale Azure Postgresql Flexible Server, but it just rolling in Started stage and nothing is happening. What could cause this? Server is working fine but we need more cores to keep up with demand, but currently unable to scale up.

I am trying to scale Azure Postgresql Flexible Server, but it just rolling in Started stage and nothing is happening. What could cause this? Server is working fine but we need more cores to keep up with demand, but currently unable to scale up. I have…

Azure Database for PostgreSQL
asked 2025-06-09T21:42:41.84+00:00
Mikko Uusitalo 25 Reputation points
edited an answer 2025-06-17T11:06:29.35+00:00
Mihir Saxena 0 Reputation points Microsoft External Staff Moderator
1 answer

Java non-admin ad user can't login--Azure AD user token for role[******@xxxxx.onmicrosoft.com] does not match auth_oid.

Hi: Following the quick start guide, Quickstart: Use Java and JDBC with Azure Database for PostgreSQL flexible server, in the link below I was able to use psql to login to PostgreSQL using the AD admin & non-admin users (after login via az login…

Azure Database for PostgreSQL
asked 2025-06-16T03:51:32.03+00:00
Lai, Tim 0 Reputation points
commented 2025-06-17T01:10:10.3133333+00:00
Vijayalaxmi Kattimani 3,250 Reputation points Microsoft External Staff Moderator
1 answer

Why is storage usage increasing consistently and overloading our Azure Postgresql server?

Storage usage has been consistently increasing in our Postgresql server since May 28th until yesterday, when it got overloaded. The effective size of the database is around 20GB, while the database storage used has reached 120+ GB. Why is it happening? …

Azure Database for PostgreSQL
asked 2025-06-16T20:40:59.9533333+00:00
Khan, Sifat Shahriar 5 Reputation points
commented 2025-06-16T23:13:37.7233333+00:00
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure PostgreSQL Flexible Server stuck in "DROPPING" state

Hello, A couple of resource groups with a VNet and Azure PostgreSQL Flexible Server were deployed yesterday. Due to misconfigurations, a decision was made to remove the entire resource groups, including the resources. Unfortunately, Azure is unable to…

Azure Database for PostgreSQL
asked 2025-05-29T06:03:58.8366667+00:00
mrb777-1232 25 Reputation points
commented 2025-06-16T20:42:13.0333333+00:00
Lav Patel 0 Reputation points
1 answer

How to add metadata for every record in Azure postgres tables

Hi, I have a situation in one of the applications I am working on where prior to going live in production, we are going to migrate data from legacy systems over the period of few weeks. And at the same time, there will be activity from users in this…

Azure Database for PostgreSQL
asked 2025-06-10T14:08:12.63+00:00
Parag Kale 25 Reputation points
answered 2025-06-13T10:38:15.3666667+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer

We need to encrypt postgres instance with a customer CMK from another tenant.

We have a use case where we need to encrypt data at rest for a postgres instance inside our tenant but using a customer CMK. The customer is hosted in an external microsoft tenant - is this possible? According to doc re:…

Azure Database for PostgreSQL
asked 2025-06-05T23:54:00.8066667+00:00
Rohit Khansili 20 Reputation points
edited an answer 2025-06-12T16:51:13.4+00:00
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

I want to Migrate database resources from one subscription to another subscription with in Azure

We have a Postgres flexi database provisioned in unmamaged subscription in Azure and now we want to migrate to a managed subscription, so want to understand what is the best possible approach.

Azure Database for PostgreSQL
asked 2025-05-22T09:22:04.47+00:00
Mukesh Tanuku 20 Reputation points
edited a comment 2025-06-12T09:24:25.58+00:00
Adithya Prasad K 1,375 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Create extension in Azure PostgreSQL

It seems that there is a bug in the Azure document. According to this link (https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions), it said that the user that creates the extension must be a member of the azure_pg_admin…

Azure Database for PostgreSQL
asked 2025-06-05T06:30:50.3666667+00:00
Cuong Tran 20 Reputation points
accepted 2025-06-12T09:20:10.27+00:00
Cuong Tran 20 Reputation points
2 answers One of the answers was accepted by the question author.

How do I request region enablement for PostgreSQL Flexible Server in Germany West Central?

How do I request region enablement for PostgreSQL Flexible Server in Germany West Central??

Azure Database for PostgreSQL
asked 2025-04-23T03:07:23.2466667+00:00
Matthew Steele 20 Reputation points
commented 2025-06-12T08:03:25.0666667+00:00
Johannes Mohren 0 Reputation points
1 answer

Facing issue while migrating azure postgres flexi server to GCP

We are currently migrating data from an Azure Database for PostgreSQL – Flexible Server instance to Google Cloud PostgreSQL using Google’s Database Migration Service (DMS). A HA VPN tunnel has been successfully established between Azure and GCP, with BGP…

Azure Database for PostgreSQL
asked 2025-06-02T11:55:41.8166667+00:00
Vaidehi Wadnerkar 0 Reputation points
commented 2025-06-11T16:06:37.2666667+00:00
PratikLad 1,825 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to achieve blue/green upgrades in Azure Database for PostgreSQL flexible server

Hi Greetings, I was looking at options that can help us achieve a blue/green upgrades pattern for updating compute configs for our Azure Database for PostgreSQL flexible server, I had explored read replica promotion to primary and promotion to…

Azure Database for PostgreSQL
asked 2025-06-09T09:54:19.9866667+00:00
Yash Gupta 20 Reputation points
accepted 2025-06-11T05:21:28.7+00:00
Yash Gupta 20 Reputation points