Perhaps utilizing AWS Load Balancer along with AWS RDS (PostgreSQL) or Aurora could work which would take care of all the failover and replications needed. Haven't done it, but certainly looks like a path to explore.
View attachment 1308
Yeah for sure! that is very interesting. I like how this thread has evolved with these suggestions, making use of these parts of AWS, I am sure there is similar stuff in GCP and Azure, could be an interesting route
I only have a basic handle on AWS, trying to figure out peering across regions but with the suggestion of EFS and this, haha thats a lot of research to be done