4 ms·
I’ve set up both pgbouncer and wal-e in the past, and they’re both worth it to have from effectively the very beginning. But it leaves me wondering: is there a
by derefr 9y ago
I’ve set up both pgbouncer and wal-e in the past, and they’re both worth it to have from effectively the very beginning.
But it leaves me wondering: is there any sort of packaging of Postgres and these “friends” into a single opinionated virtual appliance, such that I could just stick up a couple of VMs with the same image with different role tags, and get a good cluster with automatic transparent N:M proxying, automatic transparent backup-and-restore, etc?
In other words, is there a product that is to Postgres as Gitlab CE is to Github (or like Dokku is to Heroku): a “host it yourself, but easily, and starting from a scale of 1 with no overhead” equivalent of a SaaS service?
- snuxoll 9y agoIf you're deploying on K8S at least Crunchy Data has you covered [0], I haven't used it myself but it's the closest I've been able to find without going with something like EnterpriseDB. I'm pretty sure there's some ansible/puppet/chef/saltstack code out there to build something similar as well. [0] https://github.com/CrunchyData/crunchy-containers https://github.com/CrunchyData/crunchy-containers
- mslot 9y agoThere's a postgres operator by Zalando which sets up postgres with WAL-E and auto failover using Patroni. https://github.com/zalando-incubator/postgres-operator https://github.com/zalando-incubator/postgres-operator