How to stop a Postgresql stuck in "Starting" state and can't be stopped

Question

Hi,

We currently have a Postgresql DB stuck in 'Starting' and I'm unable to stop it from Azure Portal or Azure CLI.

Whats the way to resolve this issue?

Regards,

Matthew

Answer 1

Hey Matthew Y,

It sounds like you're facing quite a hassle with your PostgreSQL database being stuck in the "Starting" state. Here are some steps you can take to try and resolve this issue:

1. Check Current Status: Start by checking the status of your PostgreSQL server via the Azure Portal. Sometimes it might just be a temporary glitch.
2. Force Stop through Azure CLI: If you're unable to stop it from the Azure Portal, you can attempt to forcefully stop it using the Azure CLI. Here's the command:
   az postgres server stop --name <YourServerName> --resource-group <YourResourceGroupName>

      
         Make sure to replace `<YourServerName>` and `<YourResourceGroupName>` with your actual server and resource group names.
         
   

3. Restart the Instance: If stopping isn't working, you might want to restart the entire PostgreSQL server. Again, you can do this via Azure CLI:

      az postgres server restart --name <YourServerName> --resource-group <YourResourceGroupName>
   

4. Check Logs: After trying to stop or restart the server, check the server logs in the Azure Portal under the "Logs" section. This could give you more insight into why the server is stuck.

I hope this helps to get your PostgreSQL DB back on track! If you have any more questions or need further assistance, feel free to ask.

References:

• Azure Database for PostgreSQL Documentation
• Azure CLI Commands for PostgreSQL

Thanks!

Kalyani