5 ms·
FWIW, we use: https://pgbackrest.org/ https://pgbackrest.org/ Offers point-in-time recovery which is an improvement over a custom solution we used to have whic
by rsyring 2mo ago
FWIW, we use: https://pgbackrest.org/ https://pgbackrest.org/
Offers point-in-time recovery which is an improvement over a custom solution we used to have which gave us nightly backups.
We have it backing up to Backblaze B2 (S3 like). Was relatively easy to setup and no problems really.
- Tostino 2mo agoCan't recommend pgbackrest enough. It's fantastic software, and I love the work they put into doing inter-file deltas for backups (so if 8kb of a 1gb file changes, you only backup the difference). It saved my last company a ton of money on storage while keeping good RTO/RPO.
- k_bx 2mo agoIt's great, but it's not incremental like git, e.g. you do need to make a full backup periodically, unfortunately. I didn't understand that, and after 5 months of usage caught my backblaze to be using 40TB, and nightly restores taking forever for other reasons. So: not ideal, and be careful to check!
- Tostino 2mo agoHeh, yeah I suppose there are still some foot guns if you don't understand how things work.
- CodesInChaos 2mo agoThere was some recent uncertainty about pgBackRest getting discontinued due to lack of funding. But the maintainer secured funding, and pgBackRest development will continue. https://pgbackrest.org/news.html https://pgbackrest.org/news.html