I need help with a complex (for me) multi server setup with PostgreSQL.
I have to setup a Cloud Server and 3 Local Servers for our company.
Each Server will have:
Users will normally connect to the Cloud instance for work. But if the Cloud is down, users need to access local on each location.
How can i realize this scenario? What should i use for PostgreSQL replication or sync?
Thanks in advance