3 ms·
You get streaming replication out of the box now and you get WAL-based replication assuming you configure a shared drive or use something like S3. The latter is
by akurilin 11y ago
You get streaming replication out of the box now and you get WAL-based replication assuming you configure a shared drive or use something like S3. The latter isn't super fun to setup automation for. Also not much of a story for logical replication (tried slony, meh, feels like a relic of olden days when every deployment was carefully hand-massaged into existence) and for automated failover.
Nowadays you actually can skip a lot of setup automation with RDS, with backups, read mirrors and automated failover taken care of for you, although you frequently hear folks complain about some of those scenarios not working as nicely as you'd expect.
- travisby 11y agoHeroku has open-sourced the product they use to upload WAL files to S3. Can confirm (not with S3, but with Swift) that it works fantastically: https://github.com/wal-e/wal-e https://github.com/wal-e/wal-e