1,720 questions with Azure Database for PostgreSQL tags

Sort by: Updated
2 answers

i need some help with postgresql flexible server and restoring a backup

we just did this in development RG and all was well, went to restore the same day backup in staging and it is failing to deploy the database in azure, then when i go to the RG i expected the db to be recreated in i see it but i am unable to load it or…

Azure Database for PostgreSQL
asked 2025-12-05T19:27:06.1166667+00:00
Micheal Mueller 0 Reputation points
edited the question 2025-12-05T22:06:15.6666667+00:00
Micheal Mueller 0 Reputation points
4 answers

PostgreSql Entra group member sync

Hi, We're trying to use Azure database for PostgreSql flexible server with Microsoft Entra authentication, but are having some challenges and questions. We got a server up and running and set it so only Microsoft Authentication is allowed. We got a…

Azure Database for PostgreSQL
asked 2025-11-28T11:36:55.2366667+00:00
Gerben Maaijen 0 Reputation points
commented 2025-12-05T17:12:34.9433333+00:00
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator
1 answer

Unable to connect to database

Unable to connect the database- Unavailable (Unplanned) An unexpected problem is preventing restoring access to your Azure Database for PostgreSQL - Flexible server. We are working on resolving the problem.

Azure Database for PostgreSQL
asked 2025-12-02T08:22:33.5+00:00
Dinesh Patturi 0 Reputation points
commented 2025-12-05T16:47:39.7333333+00:00
Manoj Kumar Boyini 1,250 Reputation points Microsoft External Staff Moderator
1 answer

I cannot scale the Postgres Flexible server up.

I cannot scale the Postgres Flexible server up. Options to scale it on Compute + Storage do not show up. Is there any reason for that?

Azure Database for PostgreSQL
asked 2025-12-03T19:14:46.7866667+00:00
Julian Urrego 0 Reputation points
commented 2025-12-04T22:16:10.48+00:00
Pilladi Padma Sai Manisha 500 Reputation points Microsoft External Staff Moderator
1 answer

PG_Restore longrunning

PG_Restore longrunning morethan 24 hrs on azure postgresql server ( Standard_D4ds_v4 (4 vCores, 16 GiB memory, 6400 max iops) source database size is 2.8 TB .How to improve the pg_restore performance duration pg_dump only taking 8 hrs

Azure Database for PostgreSQL
asked 2025-11-25T12:57:38.1966667+00:00
commented 2025-12-04T10:26:58.2033333+00:00
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator
2 answers

unable to connect to my endpoint

I am not able to connect to my, it went to updating status where I did not execute an update, this started yesterday around 4:40pm EST and it is still doing an update. I did a restore, and I could not connect to the restored db as well. I need an urgent…

Azure Database for PostgreSQL
asked 2025-11-20T15:10:39.41+00:00
JaimeMallari-5866 0 Reputation points
edited the question 2025-12-04T06:19:41.35+00:00
Manoj Kumar Boyini 1,250 Reputation points Microsoft External Staff Moderator
2 answers

Capacity is not available in this region/zone. Please retry after some time - PostgreSQL EastUS

We are facing an issue with scaling up PostgreSQL flexible server. Error Detail: Type: Microsoft.DBforPostgreSQL/flexibleServers CorrelationID: 6856de9b-d5ce-4c26-ac3b-a52e6186c664 TrackingID: 920f937f-2e62-47a7-86a7-1e175c25e0da ServiceRequestID:…

Azure Database for PostgreSQL
asked 2025-12-02T13:45:48.3566667+00:00
Praveen M 0 Reputation points
commented 2025-12-04T03:55:44.9866667+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
2 answers

Capacity is not available in this region/zone

We are trying to select the compute tier from General Purpose (2-96 vCores) - Balanced configuration for most common workloads TO Memory Optimized (2-96 vCores) - Best for workloads that require a high memory to CPU ratio. Along with this we are trying…

Azure Database for PostgreSQL
asked 2025-12-02T09:36:08.82+00:00
Chaitali Rane 0 Reputation points
commented 2025-12-04T03:54:17.02+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
1 answer

Azure PG Database Unable to Start

Hello, I am having trouble starting my database. It suddenly stopped responding and I am unable to restart, stop and start it. I tried doing a Restore. None of this worked as the task hangs and fails. Pinging the database also does not yield any results…

Azure Database for PostgreSQL
asked 2025-11-30T19:54:32.6266667+00:00
Mew 0 Reputation points
commented 2025-12-04T03:49:32.13+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
2 answers

Azure Flexible Postgres Server (v17) missing Storage Used/Percent Metrics

Storage metrics are not showing since the server was created around 2 weeks ago. CPU/Memory/Transaction Logs and other metrics all show up properly and the server is working fine otherwise. Restarting did not help. Changing Server Parameters did not…

Azure Database for PostgreSQL
asked 2025-12-03T12:21:58.32+00:00
Mohamad Hadla 0 Reputation points
answered 2025-12-03T12:37:51.1233333+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
1 answer

What is causing the following log message in server logs every second: background worker \"azure_mise_service_worker\" (PID 1638153) exited with exit code 1

As in the question here: https://learn.microsoft.com/en-us/answers/questions/5567485/what-is-causing-the-following-log-message-in-serve However, the answers there are not helping me. I have 4 PostgreSQL flexible servers, and they ALL log this…

Azure Database for PostgreSQL
asked 2025-11-12T12:28:54.65+00:00
fta 5 Reputation points
commented 2025-12-03T09:45:15.48+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
2 answers

Azure Database PostgreSQL private access (virtual network integration) DNS resolution issue

My team is currently running into a very specific issue with several Azure Database PostgreSQL servers, configured using private access (virtual network integration), and DNS resolution and connectivity to those servers from within several AKS…

Azure Database for PostgreSQL
asked 2025-12-02T23:03:38.64+00:00
Roccuzzo, Matt 5 Reputation points
answered 2025-12-03T07:32:10.59+00:00
VRISHABHANATH PATIL 1,820 Reputation points Microsoft External Staff Moderator
2 answers

Moving to another VNet

I want to move my Azure Database for PostgreSQL flexible server from one VNet to another. Both VNets are in the same resource group but in different regions. How to get it done?

Azure Database for PostgreSQL
asked 2025-12-01T07:10:27.5966667+00:00
Ashwini Nighthack 0 Reputation points
answered 2025-12-03T07:04:53.3+00:00
VRISHABHANATH PATIL 1,820 Reputation points Microsoft External Staff Moderator
1 answer

Upgrading Azure Database for PostgreSQL flexible server trough portal Upgrade button - fail_fast requires a value

Greetings! I'm trying to update major version of postgres (Azure Database for PostgreSQL flexible server) trough Azure portal's "Upgrade" button. I've tried upgrading from version 15 -> 17 and from 16 -> 17, but both were unsuccessful…

Azure Database for PostgreSQL
asked 2025-12-02T08:33:21.32+00:00
Tilen Rupnik 0 Reputation points
commented 2025-12-03T06:50:40.9066667+00:00
Manoj Kumar Boyini 1,250 Reputation points Microsoft External Staff Moderator
1 answer

I cant connect from the terminal or anywhere else to the admin POSTGRESQL even after changing the password, it still says password authentication failed

So yeah like the title says, I could not connect to the POSTGRESQL flexible servers from my terminal or VS code extension despite even changing passwords, this is for the admin user so I have no access to the database no matter what. There are no users…

Azure Database for PostgreSQL
asked 2025-12-02T07:39:24.0366667+00:00
Khaula Al Kindi 0 Reputation points
answered 2025-12-02T09:33:20.2233333+00:00
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator
3 answers

PostgreSQL flexible server stuck in "updating" state

I attempted a to scale a PostgreSQL flexible server within the same CPU class and it has been stuck in "updating" status for over an hour. The server is currently in 'updating' state. Please wait for the operation to complete. You can refresh…

Azure Database for PostgreSQL
asked 2025-11-20T23:19:17.0433333+00:00
C Thompson 5 Reputation points
commented 2025-12-02T09:05:13.24+00:00
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator
2 answers

PGROUTING extension fails to deploy when added to postgres 16

PGROUTING extension was added recently to the extension list for postgres 16. However when I add that extension to my postgres v16 this is failing to deploy.

Azure Database for PostgreSQL
asked 2025-10-23T13:45:37.9966667+00:00
Christian Shardey 0 Reputation points
commented 2025-12-02T06:01:51.49+00:00
VRISHABHANATH PATIL 1,820 Reputation points Microsoft External Staff Moderator
0 answers

Issue Resolved

Issue resolved, server eventually stopped and I was able to start it again.

Azure Database for PostgreSQL
asked 2025-12-01T19:25:44.4166667+00:00
Neil Littlejohns 0 Reputation points
commented 2025-12-01T20:50:59.0033333+00:00
Pilladi Padma Sai Manisha 500 Reputation points Microsoft External Staff Moderator
0 answers

Azure Database for PostgreSQL Flexible Server won’t start after being stopped; returns InternalServerError

Hello Azure team, My Azure Database for PostgreSQL Flexible Server has been in a stopped state for approximately 4 weeks, and I’m unable to start it again. Whenever I try to start the server from either the Azure Portal or the CLI, I receive the…

Azure Database for PostgreSQL
asked 2025-10-22T01:15:42.17+00:00
Yantra 0 Reputation points
commented 2025-11-30T20:38:28.6266667+00:00
Yantra 0 Reputation points
2 answers One of the answers was accepted by the question author.

Azure PostgresSql Flexible Server SKU scaling and HA enablement with ARM template error

HI, We have an Azure Database for PostgreSQL Flexible server, SKU Burstable B1ms, deployed with an ARM template. We want to now enable HA and have a standby for this server, and, as part of this process, we made the following changes to the ARM…

Azure Database for PostgreSQL
asked 2025-11-27T18:08:36.5866667+00:00
Dev S 131 Reputation points
accepted 2025-11-28T19:41:30.5766667+00:00
Dev S 131 Reputation points