Azure postgresql server getting stuck

MR Subbato 0 Reputation points
2024-12-23T14:24:57.3633333+00:00

My Azure PostgreSQL managed database server is stuck. I tried connecting to it, but it didn't work. When I attempted to restart the server, I received the error: "The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long." What should I do now?

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 57,581 Reputation points
    2024-12-23T16:13:06.4333333+00:00

    Hi Mr Subbato,

    First, try to completely stop the service and wait 10 minutes and then start it. If this doesn't work I would recommend creating a ticket with Azure Support if it is still stuck:

    https://azure.microsoft.com/en-ca/support/create-ticket


    If this is helpful please accept as answer or upvote.

    Best regards,

    Dillon Silzer

    0 comments No comments

  2. RahulRandive 10,066 Reputation points
    2024-12-28T10:50:56.3966667+00:00

    Hi @MR Subbato

    Try restarting the server using the Azure CLI or portal. This can sometimes resolve issues with stuck updates.

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restart-server-portal

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restart-server-cli

    If your server is reaching resource limits (CPU, memory, IOPS), it can cause updates to hang. Check the resource usage and consider scaling up if necessary.

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-limits

    You can wait for sometimes because it might be resolved itself or as suggested above, please open a support ticket.

    Thank You.


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.