Does Postgres regional failover happen automatically?

2

I have been trying to better understand this topic as well over here:

https://community.fly.io/t/better-understanding-best-practices-for-ha-for-both-web-apps-and-pg-apps