Hi @Mohan Kumar S ,
Welcome to Microsoft Q&A forum.
As I understand, you have Azure Postgresql Flexible server with West Europe as primary region.
And want to know automatic failover to secondary region.
Unplanned outages include software bugs or infrastructure component failures that impact the availability of the database. If the primary server becomes unavailable, it is detected by the monitoring system and initiates a failover process. The process includes a few seconds of wait time to make sure it is not a false positive. The replication to the standby replica is severed and the standby replica is activated to be the primary database server. That includes the standby to recover any residual WAL files. Once it is fully recovered, DNS for the same end point is updated with the standby server's IP address. Clients can then retry connecting to the database server using the same connection string and resume their operations.
If the question is: Can I configure HA across regions?
No. HA is configured within a region, but across availability zones. In future, we are planning to offer read replicas that can be configured across regions for disaster recovery (DR) purposes. We will provide more details when the feature is enabled.
Is zone redundant HA available in all regions?
Zone-redundant HA is available in regions that support multiple AZs in the region. For the latest region support, please see this documentation. We are continuously adding more regions and enabling multiple AZs. Same-zone HA is available in all supported regions.
Reference Link: HA configuration options
Hope this helps. Let us know if your question is different to my understanding and require more insights.
Hi @Mohan Kumar S.
Following up to see if the below suggestion by Geetha was helpful. If this answers your query, do click
Mark Helpfulfor the same. And, if you have any further query do let us know.