How and where to check with Azure Postgres Flexi server is restarted or not

Molagara, Bhanu P 20 Reputation points
2023-02-28T13:29:56.6033333+00:00

How and where to check with Azure Postgres Flexi server is restarted or not

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. SSingh-MSFT 16,371 Reputation points Moderator
    2023-02-28T14:21:50.02+00:00

    Hi @Molagara, Bhanu P ,

    Welcome to Microsoft Q&A forum and thanks for using Azure services.

    As I understand, you want to know how and where to see if an Azure Database for PostgreSQL flexible server is started or not.

    To check the current status of the Azure Database for PostgreSQL flexible server, open the server and inside the Overview tab at the top you can see the Current status as "Start" or "Stop":

    User's image

    If it is at stopped state, this page will have a button to "Start".

    This could be also checked through Azure CLI with command az postgres flexible-server show --resource-group xyz --name testflexservershakti

    User's image

    If the server is at Ready State i.e Started, then it is shown as Available:

    User's image

    And, when you try to "Restart" the server using the Restart button, it will also show in the notification panel on the right side and temporary status until it gets Restarted as "Stopped":

    User's image

    At CLI, status will be "Restarting":

    User's image

    Once it is Restarted successfully, it will show as Available:

    User's image

    Hope this helps. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

    0 comments No comments

  2. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-02-28T14:56:54.85+00:00

    Thanks for your question.

    You can check the server Activity logs to see if there were any restart events.

    You can find logs like below –

    User's image

    Also, you can find details and events from Resource health section-

    User's image

    Thank you!

    0 comments No 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.