Share via

We're unable to access Azure PostgresQL DB

Dev 40 Reputation points
2026-05-07T06:51:36.9266667+00:00

W've been using Azure PostgresQL flexible server for our application, since few hrs we're facing the issue accesing the DB, this was business critical DB

Insights:

When we try to update any configuration, got the below error

{

"status": "Failed",

"error": {

"code": "InternalServerError",

"message": "An unexpected error occured while processing the request. Tracking ID: '9ec203f7-ce23-4a40-9af8-8cbfd8e4bd5f'"

}

}

and we see there were no spikes in memory, CPU, and failed connections as well

Can u guys check and let me know possibilities to restore this ?

Azure Database for PostgreSQL

Answer accepted by question author

  1. Manoj Kumar Boyini 14,415 Reputation points Microsoft External Staff Moderator
    2026-05-11T05:25:54.9666667+00:00

    Hi Dev

    Thank you for your detailed questions — please find the clarifications below:

    The issue was caused by a temporary unhealthy state of the underlying service components hosting the database. This led to connectivity failures and management operations (such as configuration updates and backup actions) returning errors.

    The service has since been recovered, and the server is now in a healthy state.

    This type of issue is not tied to a specific compute tier (Burstable, General Purpose, or Memory Optimized) and is considered tier-agnostic.

    However, for production workloads, the General Purpose or Memory Optimized tiers are recommended, as they provide better performance consistency, higher availability characteristics, and are more suitable for business‑critical applications compared to Burstable tiers.

    In scenarios where the server becomes unreachable or management operations fail:

    Point‑in‑Time Restore (PITR) remains the recommended and supported recovery option. PITR creates a new server using existing backups and does not depend on the current health of the source server.

    Automated backups are maintained independently of portal actions like on-demand backups. Even if on-demand backup fails due to the server state, the automated backup chain is typically still usable for recovery.

    A restore operation always provisions a new server and does not overwrite the existing one.

    Data loss: You can restore to a specific point in time within the configured backup retention period, which generally allows recovery without data loss up to the selected restore point.

    Recommended approach:

    Perform a PITR to restore the database to a new server.
    Validate application connectivity and data consistency on the restored server.
    Once the issue is resolved and no longer needed, you can safely delete the original server to avoid ongoing charges.

    Please let us know if you have any questions or concerns.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Manoj Kumar Boyini 14,415 Reputation points Microsoft External Staff Moderator
    2026-05-08T10:52:51.44+00:00

    Hi Dev

    Our PG Team identified that the underlying VM and database containers were in an unhealthy state, which caused the connectivity and operation failures you experienced.

    The containers have now been restarted, and the server is back in a Succeeded / healthy state. You should now be able to access the database and perform operations as expected.

    As a best practice, if you encounter similar situations in the future where the server becomes unreachable, you can use Point‑in‑Time Restore (PITR) to recover the database to a new server. This process is fully managed and allows you to restore your data without any data loss within the configured backup retention period.

    If you need any assistance with restore operations or face any further issues, please feel free to reach out here we’ll be happy to help.

    Hope this helps, Please let us know if you have any questions or concerns.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Dev 40 Reputation points
    2026-05-12T04:15:08.93+00:00

    Hi Team,

    We're unable to make changes to this server,

    After your team intervention we got the server back and working fine, but when we try to do any operation on it, we're getting the below error

    Error occurred stopping the server . An unexpected error occured while processing the request. Tracking ID: '7619c6b1-76cb-491a-a26d-f144391961d3'
    

    Was this answer helpful?


Your answer

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