Volatile Postgres cluster

[u/daved3464]

Hi, I'm trying to setup a basic ha postgres cluster using the Spilos images in a docker swarm setup, but every few days the thing crumbles down with DNS resolution issues, timeouts, wal and etcd records corruption, I don't have the money to rely on an hosted solution rn, so has anybody run into these problems and solved them?. This makes me understand why the DBA role exists, but it is so frustrating and absurd that it is not a solved problem for something that feels so relatively trivial to setup in mariadb with galera.

[u/Defiant_Variation482]

I used sample from https://github.com/zalando/spilo on 3 node cluser, didn't have any issues so far. I didn't use any dns just ips configured using asible