3 ms·
Coincidentally I’ve been trying to figure out a nice no-nonsense way to setup a HA postgres cluster with automatic failover and restoration of nodes and point i
by mosselman 1y ago
Coincidentally I’ve been trying to figure out a nice no-nonsense way to setup a HA postgres cluster with automatic failover and restoration of nodes and point in time recovery.
I see a lot of patroni with etcd and haproxy being advised. It must work well for people to be so excited about it, but it feels a bit overwhelming to me when I look at the docker compose files.
At the same time there is pgool which looks like mostly a single thing to deploy in front of each postgres server.
Any tips from the pg-interested people here?
I’d like a docker compose like experience to setup a cluster that is highly available with point in time recovery or at least no data loss.
- fancy_pantser 1y agoAre you looking for a tool like Barman?
- hans_castorp 1y agoFor failover handling repmgr is probably better (they can work together though)
- mosselman 1y agoThanks. What role does repmgr play?
- mosselman 1y agoI don't know. Barman would only be part of the HA puzzle no?
- Tostino 1y agoI've been using cloudnativepg and it is pretty turn key for all of that.
- nijave 1y agoNeeds Kubernetes, though which might throw a complexity wrench in if you're not familiar. If you are familiar, then it's about as turn-key as you can get. There's also a different PG operator based on Patroni that's supposed to work pretty well iirc