3 ms·
The author mentioned using https://www.pgbarman.org https://www.pgbarman.org for this, with a freelance DBA. Does anyone else have experience between the two o
by rattray 8y ago
The author mentioned using https://www.pgbarman.org https://www.pgbarman.org for this, with a freelance DBA.
Does anyone else have experience between the two options?
- jsiepkes 8y agoI can attest that pgbarman works great. cough I accidentally nuked a production server once. However thanks to barman the downtime was only tens of minutes. It works by making a full backup at fixed intervals (say weekly) and then "pretending" to be a replica which makes it receive all the changelogs in realtime. (Basically it receives and archives WAL's). This makes point in time recovery possible. Highly recommended.
- mmckelvy 8y agoI've used Barman for physical backups (I used the streaming backup option). Works well, though it's a bit of a slog to get set up the first time (the docs can be confusing in some areas) but once it's up it's great.