I'm trying to setup a "Serverless" PostgreSQL data replication architecture.
Here's what I'm trying to do:
I'm trying to install a PostgreSQL database in every machine and then have that data synchronize between all available servers.
I've tried SymmetricDS but it does not allow me to do a mesh type network. I'm currently trying EDB Replication Server, but I need to have a centralized point to install the server. If it were possible to install the server on every machine and then have it sync between each other would be great, but it doesn't seem possible.
Any tips on how to achieve Multi-master "serverless" architecture in postgresql? Any success stories and tips would be appreciated.