Azure felxible postgres stuck at restarting

Question

My postgres flexible server seems to be in restarting state for entire day. The storage space of 32 GB seems to be exhausted, so it went into recovery state, then it was not coming back from that state for any connection, then i tried to restart it, and I cant increase the storage as it's still restarting. I tried both Azure portal and CLI to increase storage. Any solutions ?

Answer 1

Hi @ An1gupta

Thanks for the Question and using Microsoft Q&A platform

Sometimes, long-running transactions can cause the server to get stuck in a restarting state. You can check for any long-running transactions and try to terminate them if possible

If it is an intermittent issue, it can get fixed by own

Please refer to the below similar "Accepted thread" that might help you:

https://learn.microsoft.com/en-us/answers/questions/1818159/azure-postgresql-flexible-server-stuck-in-restart

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restart-server?source=recommendations&tabs=portal-restart-server

Hope this helps. Do let us know if you any further queries If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi @An1gupta

Since the storage is full, the restart may have gotten stuck, preventing you from increasing the storage or restarting the server.

The possible option would be to contact the support team so they can free up some storage space, bring the server back online, and then allow you to expand the storage.

Thank You!