Damus
alto · 61w
How are people here running #postgres in #highavailability mode when #selfhosting?
Sheogorath profile picture
@nprofile1q... with the Zalando-postgres-operator. It's really fun and incredibly stable.

The legwork is done by patroni and the SPILO images that manage backup and restore as well as fail over.

I've never ran more solid databases. Deleted the volume? Spilo just recovers from the basebackup + WAL archive before start postgres. No manual recovery needed.

https://postgres-operator.readthedocs.io/en/latest/
1
alto · 61w
nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqz60lpnvpzm8slq8c2kjs7n8jzlqwdrjsrq22qg5d44s60xds8c5qqj5kdd I'm sure the operator is quite good, but it's kubernetes specific so it doesn't apply to my situation unfortunately