Azure PostgreSQL flexible server stuck in restart state

Question

I tried to restart my Azure Database for PostgresSQL flexible server now more than two days ago and it is still stuck in the restarting status. I initiated the restart because it wouldn't show me the list of databases so I could manually connect to them through the Azure portal.

Answer 1

can you check the following article for the issue
especially long-running transaction may cause this problem

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/why-restarting-azure-database-for-postgresql-took-long/ba-p/1885780