"High Availability and Failover Configuration in PostgreSQL Flexible Server"

Hi @ Priyanka Mamidiyala

To configure automatic failover and high availability in Azure Database for PostgreSQL Flexible Server, you can use zone-redundant high availability (HA), which deploys a standby replica in a different availability zone.

Key Steps for Automatic Failover

Enable high availability during server creation.

Choose zone-redundant HA for optimal resilience.

The system uses synchronous replication, ensuring no data loss.

In case of primary server failure, the standby automatically takes over.

Recovery Time Objectives (RTO)

For zone failures, failover typically happens within a few minutes, minimizing downtime.

For cross-region recovery, manual intervention may be required.

For more details, you can check Microsoft’s documentation:

Azure PostgreSQL Flexible Server High Availability.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.