Does Postgres regional failover happen automatically?

Thanks @shaun - I am actually reading through that topic as we speak.

As for describing some of the scenarios, I have had a topic open here: https://community.fly.io/t/better-understanding-best-practices-for-ha-for-both-web-apps-and-pg-apps that explains some of the situations that I am trying to better understand as well as how to best set everything up for HA.