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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Issue Resolved
Issue resolved, server eventually stopped and I was able to start it again.
Azure Database for PostgreSQL
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
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
Unable to upgrade Postgresql Flexible Server from V14 to V16
Dear Azure Support, I would like to do a major upgrade of Postgres Flexible Server from V14 to V16. I always get the following error message, although I have removed extensions dblink and postgres_fdw. PS C:\Program Files\PowerShell\7> az postgres…