1,431 questions with Azure Database for PostgreSQL tags

Sort by: Updated
1 answer

Setting up PostgreSQL logical replication between two separate Azure Flexible servers

Hello, I'm trying to set up logical replication on two different Azure PostgreSQL flexible servers. The source flexible server was created with public access enabled, the replication server was initially a streaming replica promoted to a standalone…

Azure Database for PostgreSQL
asked 2025-05-21T15:01:58.1133333+00:00
Harry Georgilas 0 Reputation points
answered 2025-05-30T12:36:20.3566667+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

PostgreSQL Flexible Servers stuck in 'Dropping' state

I am unable to delete "Azure Database for PostgreSQL flexible server" in the resource group. The resource is in "dropping" state & the error I see on "overview" page is: Cannot read properties of undefined (reading…

Azure Database for PostgreSQL
asked 2025-05-30T05:54:24.4366667+00:00
Tomáš Krečmer 50 Reputation points
accepted 2025-05-30T09:08:42.2266667+00:00
Tomáš Krečmer 50 Reputation points
1 answer One of the answers was accepted by the question author.

How to grant permissions on database to user?

Hi, I have a Flexible Postgesql server with several databases, i.e. db01. And I want to grant INSERT,UPDATE,DELETE privileges for all tables in public schema on database db01 to user myuser01. I connected as psqladmin user and tried to run these…

Azure Database for PostgreSQL
asked 2025-05-26T09:21:23.8966667+00:00
Mykhailo Levandovskiy 20 Reputation points
commented 2025-05-30T08:13:03.11+00:00
Mykhailo Levandovskiy 20 Reputation points
1 answer

Azure Database for PostgreSQL flexible server won't accept any type of authentication

I created a Azure Database for PostgreSQL flexible server resource, and have followed all available documentation to connect to it. No matter what I try, it gives me the same error. port 5432 failed: FATAL: password authentication failed for…

Azure Database for PostgreSQL
asked 2025-05-28T02:42:29.0566667+00:00
Ryan Shannon 0 Reputation points
commented 2025-05-30T00:49:57.33+00:00
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator
1 answer

Azure scale deployment freeze

Hello, Azure scale deployment freeze in the loading state. No possibilities to cancel or delete it. Support request is not available for a Basic plan. This is the issue on the side of Azure. How it can be resolved without the support request?

Azure Database for PostgreSQL
asked 2025-05-29T20:54:18.9866667+00:00
Andrii K 0 Reputation points
answered 2025-05-29T22:41:12.65+00:00
Prasad Chaganti 770 Reputation points Microsoft External Staff Moderator
1 answer

My Azure Postgresql Server is down. How can we fix it and bring it back to live as soon as possible?

Our azure postgresql server went down. We updated the compute configuration from burstable to general and the server has been down for hours now, without any clear reason why.

Azure Database for PostgreSQL
asked 2025-05-28T16:39:10.3233333+00:00
Khan, Sifat Shahriar 5 Reputation points
commented 2025-05-29T22:06:23.6766667+00:00
Mahesh Kurva 5,210 Reputation points Microsoft External Staff Moderator
1 answer

Azure Database for PostgreSQL - Flexible server is currently unavailable.

Hello, UnknownReason (Unplanned) Your Azure Database for PostgreSQL - Flexible server is currently unavailable. We are working to resolve the problem. database is being affected by a resource health event. Status: Unavailable Last update: Your Azure…

Azure Database for PostgreSQL
asked 2025-05-28T16:05:32.69+00:00
Gade, Shubham 0 Reputation points
commented 2025-05-29T19:09:12.0266667+00:00
Mahesh Kurva 5,210 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Not able to deploy virtual endpoints for the postgres flexible server

I tried to deploy virtual endpoints after setting up the replica for the flexible server, but there is error showing that " "Server has 1 virtual endpoint of type ReadWrite. More than 1 │ virtual endpoints are not allowed of type…

Azure Database for PostgreSQL
asked 2025-05-22T16:00:44.3433333+00:00
Wang, Yue 60 Reputation points
edited the question 2025-05-29T17:41:47.1866667+00:00
Wang, Yue 60 Reputation points
1 answer

PostgreSQL Server is no longer visible in My Resources

The server I am working with is readily available and can connect to perfectly fine, but I am no longer able to view it within My Resources in the Azure Portal. Not sure what is going on at this point just need someone to assist and support cases were…

Azure Database for PostgreSQL
asked 2025-05-23T15:25:41.2533333+00:00
IT Department 0 Reputation points
edited an answer 2025-05-29T13:14:44.19+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How do I fix a postgres db (flexible) that is stuck in dropping state.

How do I fix a postgres db (flexible) gthat is stuck in dropping state. It was never created, during creation something failed, triggering dropping state. Additionally I cant see it in the CLI and hence cant troubleshoot.

Azure Database for PostgreSQL
asked 2025-05-12T20:02:40.23+00:00
Jayden Pienaar 20 Reputation points
accepted 2025-05-29T12:50:28.8633333+00:00
Jayden Pienaar 20 Reputation points
1 answer

Azure Database for PostgreSQL flexible server stuck in restarting state

A restart of an Azure Database for PostgreSQL flexible server was initiated today at 15:58:34 GMT+0200. It has remained in a restarting state for over an hour. What steps can be taken to resolve this issue?

Azure Database for PostgreSQL
asked 2025-05-23T15:21:04.9866667+00:00
Alberto Luna 0 Reputation points
edited an answer 2025-05-29T10:50:51.3933333+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
1 answer

PostgreSQL Flexible Server stuck in 'Starting'

"The server is stuck in 'Starting' due to full storage (32GiB). Cannot stop, resize, or restart. CLI says 'Server is busy with other operations'. Please force-recover." \

Azure Database for PostgreSQL
asked 2025-05-26T08:30:11.6566667+00:00
Eli Arama 0 Reputation points
answered 2025-05-29T09:12:31.79+00:00
Narendra Pakkirigari 475 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 – ResourceNotFound in CLI and REST, but still visible in portal

Hi Team, We are experiencing an issue with a PostgreSQL Flexible Server in Azure that is stuck in a broken "Dropping" state. We attempted to delete the server, but now: It shows “Dropping” in Azure Portal Clicking it throws: "Cannot read…

Azure Database for PostgreSQL
asked 2025-04-17T09:56:57.8833333+00:00
Niket Kumar Singh 715 Reputation points
commented 2025-05-29T05:39:42.7133333+00:00
Saraswathi Devadula 6,190 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure Database for PostgreSQL - Single Server-Backup

Azure Database for PostgreSQL - Single Server-was retired on 31st march 2025. We have missed the Auto migration. Now we have to perform the manual migration before that we need to take the backup of the existing postgresql server but backup also…

Azure Database for PostgreSQL
asked 2025-05-20T09:44:10.9666667+00:00
Rajuvardhana K V 60 Reputation points
commented 2025-05-29T04:10:44.59+00:00
Rajuvardhana K V 60 Reputation points
1 answer One of the answers was accepted by the question author.

Azure failed to provision a service and now I cannot create it at all

I have tried to provision a server on this service and whilst validation was successful it failed to create the service with a meaningless error. When I have attempted to recreate the provisioning, again succeeding the validation step it tells me it…

Azure Database for PostgreSQL
asked 2025-05-20T13:27:40.4133333+00:00
David Hirst 20 Reputation points
accepted 2025-05-28T16:06:11.3+00:00
David Hirst 20 Reputation points
2 answers

Postgresql flexible server impossible to delete after failed creation

Hello everyone, I have an issue on Azure. I created with the CLI a postgresql flexible server, but this creation failed with internal error: (InternalServerError) An unexpected error occured while processing the request. Tracking ID:…

Azure Database for PostgreSQL
asked 2025-05-07T09:49:51.8466667+00:00
Joshua 5 Reputation points
commented 2025-05-28T13:14:57.4366667+00:00
Arnaud de Bossoreille 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure Database for PostgreSQL flexible server stuck in starting

I suspect our server has run out of storage and has locked up. We tried stopping and starting the machine yesterday and now it is stuck in a "Starting state...". No backups, logs or anything is available currently and we have no way of…

Azure Database for PostgreSQL
asked 2025-05-28T07:49:08.06+00:00
Willo van der Merwe 20 Reputation points
commented 2025-05-28T11:04:19.5+00:00
Willo van der Merwe 20 Reputation points
1 answer

Azure Postgresql sku

What is Azure Postgresql sku selctions ? please give sku with pricing and region supported.

Azure Database for PostgreSQL
asked 2025-05-28T03:31:50.6033333+00:00
Constance Yee 5 Reputation points
answered 2025-05-28T09:52:11.3533333+00:00
Constance Yee 5 Reputation points
1 answer One of the answers was accepted by the question author.

connect to postgres flexible-server from Github Actions

I'm trying to connect to my postgre-sql on a flexible server database from github actions, following this tutorial:…

Azure Database for PostgreSQL
asked 2025-05-13T15:52:07.2266667+00:00
Sophie 20 Reputation points
accepted 2025-05-28T09:42:19.2133333+00:00
Sophie 20 Reputation points
3 answers One of the answers was accepted by the question author.

Cannot disable VNET due to an association in a subnet its delegated to Microsoft.DBforPostgreSQL/flexibleServers a reference that no longer exists

I cannot remove the association of a subnet, because that resource does no longer exists, and the actual service association link is set as allow delete = false. The allow Delete is set to false and there's nothing a mere mortal can do.. this is eating…

Azure Database for PostgreSQL
asked 2025-03-28T00:51:10.8066667+00:00
Egli Becerra 25 Reputation points
edited a comment 2025-05-27T06:40:33.96+00:00
Egli Becerra 25 Reputation points