This sounds a good idea. But there is CAP theorem which means everything is a trade off

Here let’s make explicit some of the trade offs and options across one server, many local servers and many servers across many time zones

Biblio https://www.postgresql.org/docs/current/static/high-availability.html