4 ms·
This is a problem with Postgres as well (for different reasons). I currently have a server sitting without proper DB backups (only full backups and dumps) becau
by StavrosK 7y ago
This is a problem with Postgres as well (for different reasons). I currently have a server sitting without proper DB backups (only full backups and dumps) because figuring out how Wall-E (or whatever the latest tool is) works is more effort than "here's my bucket and encryption key, please start backing everything up".
- latch 7y agoFWIW, I've had a lot of success with barman (1). If you set it up using the newer streaming protocol, which doesn't require a separate ssh channel, then it's relatively straightforward to setup. https://www.pgbarman.org/ https://www.pgbarman.org/
- candiddevmike 7y agoWAL archiving is really helpful for (any) point in time restores and backing up large databases. If neither of those apply, pgdump is great! Also WAL-E has been replaced by WAL-G (written in Go): https://github.com/wal-g/wal-g https://github.com/wal-g/wal-g