4 ms·
The only real world easy to use solution for postgres replication I’ve found, are the kubernetes operators. For example CloudnativePG. It’s not just replicatio
by andix 2y ago
The only real world easy to use solution for postgres replication I’ve found, are the kubernetes operators. For example CloudnativePG.
It’s not just replication what you need. It’s failover, recovery, monitoring, self-healing, backups, and so on.
Are there any other free/open implementations outside of kubernetes?
- xtracto 2y agoI used the wal feature with a bash script that compressed the wal into .xz files (-9 compression) every 10,000 lines and stored those files in s3fs folder. This as a type of "online" backup solution.
- andix 2y agoSure, but you probably want some automated snapshot recovery on a node that has a quite recent replica. Restoring a complete backup might take hours or days, and in a desaster scenario you want to be back online within a few minutes. Probably even without manual intervention. And at the same time you want so spin up a new replica to replace the lost one.