An Azure managed PostgreSQL database service for app development and deployment.
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.