Your Azure Database for PostgreSQL - Flexible server is currently unavailable. We are working to resolve the problem.

Question

Your Azure Database for PostgreSQL - Flexible server is currently unavailable. We are working to resolve the problem.

I am not available to access the database, looks like this problem started to appear after a freeze in the payment of the subscription, but i do not have details if the database is failing because any problem or it was deleted, kindly let me know if there is any way to recover it

Answer 1

If your Azure Database for PostgreSQL - Flexible server is currently unavailable, it could be due to various reasons, including subscription issues or server deletion. If the server has been deleted, you can restore it by following these steps:

1. Check Activity Log: Go to the Azure portal, select the Monitor service, and then select Activity Log. Filter for the Delete PostgreSQL Server operation to see if the server was deleted.
2. Copy Resource ID: If you find the deletion event, copy the resourceId and submissionTimestamp from the JSON output.
3. Use REST API to Restore: Navigate to the Azure Database for PostgreSQL flexible server Create Server REST API page. Use the Try It tab to sign in and provide the necessary parameters based on the resourceId you copied. Make sure to specify the pointInTimeUTC using the submissionTimestamp you obtained.
4. Request Body: Your request body should look like this:

      {
        "location": "Your Server Location",
        "properties":
        {
          "pointInTimeUTC": "submissionTimestamp",
          "createMode": "ReviveDropped",
          "sourceServerResourceId": "resourceId"
        }
      }
   

   Replace the placeholders with the appropriate values.

If the server is simply unavailable due to subscription issues, you may need to resolve the payment issue to regain access to your database.

For further assistance, consider checking the Azure support documentation or contacting Azure support directly if you need more help with your specific situation.

Answer 2

Hi Orel Hernández Ramírez •

Greetings!!

1. Confirm that your subscription is active and payments are up to date in the Azure Portal.
2. Check the server status under Azure Database for PostgreSQL > Flexible Server.
3. If the server shows as “Stopped” or “Unavailable,” try restarting it after subscription reactivation.

Please provide above details, we can help you to recover the database.

Thank you!