4 ms·
What we do, is automated restores. We have a _hourly and an _daily restore that just happens via shell script. We encourage staff to play with both, and they c
by zie 1y ago
What we do, is automated restores. We have a _hourly and an _daily restore that just happens via shell script.
We encourage staff to play with both, and they can play with impunity since it's a copy that will get replaced soon-ish.
This makes it important that both work reliably, which means we know when our backups stop working.
We haven't had a disaster recovery situation yet(hopefully never), but I feel fairly confident that getting the DB back shouldn't be a big deal.
- hadlock 1y agoYes but did you have to write your own, or did you pull it from an official repo? I'm all for customizing things but we're a long, long ways from pg8.0, something besides the bare bones official pgdump and pgrestore binaries with their very agnostic and vanilla man pages would be tremendously useful.
- zie 1y agoAgreed. We use barman[0] and some shell. 0: https://pgbarman.org https://pgbarman.org