Share via

Postgres flexible server (Azure) will not start

James Worsfold 20 Reputation points
2025-04-14T22:22:41.7766667+00:00

Hi. My database became unresponsive, so I did a manual restart. It has been restarting for over 3 days now.

I then tried to delete the database to re-create it. This also has not worked. I cannot manage the database, but my container app that uses the database seems to run okay.

User's image

User's image

Azure Database for PostgreSQL
Accepted answer
  1. RahulRandive 10,401 Reputation points
    2025-04-16T16:02:45.53+00:00

    Hi @James Worsfold

    The server should now be up and running. Please check and confirm.

    It appears the VM was unhealthy, and to mitigate the issue, the backend team likely restarted it.

    Thank You!

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sai Raghunadh M 3,070 Reputation points Microsoft External Staff
    2025-04-14T23:58:00.1566667+00:00

    Hi @ James Worsfold

    The issue might be that the storage reached 100%, so during the restart, there wasn't enough space to restart the server.

    Another reason would be long running transactions are queries that are running for too long which impact database performance and can potentially cause issues during restarts. If it is an intermittent issue, it can get fixed by own.

    Please find the troubleshooting steps below to help resolve the issue:

    • Sometimes, the server might need more time to complete the restart process. Wait for a few more hours and then try restarting it again using the Azure portal or Azure CLI.
    • Since the portal may not allow changes while the server is restarting, try increasing the storage via Azure CLI. Increase storage beyond 100% usage (e.g., if it was 100GB, try setting it to 120GB).
    • Check if auto-growth is enabled, Azure might be attempting to allocate more space automatically. You can check this in the Azure portal under Storage Configuration.

    If storage was increased, restart the server via Azure CLI.

    az postgres flexible-server restart --resource-group <your-resource-group> --name <your-server-name>

    Please find the below mentioned links for more information.

    https://techcommunity.microsoft.com/blog/adforpostgresql/why-restarting-azure-database-for-postgresql-took-long/1885780

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-server-cli#scale-compute-and-storage

    https://docs.azure.cn/en-us/postgresql/flexible-server/how-to-restart-server-cli#restart-a-server

    If the issue still persists, please let us know here. We will respond with more details and try to help you.

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.