Remix.run Logo
rsyring 13 hours ago

FWIW, we use: 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.

CodesInChaos 11 hours ago | parent | next [-]

There 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

Tostino 13 hours ago | parent | prev [-]

Can'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 10 hours ago | parent [-]

It'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 10 hours ago | parent [-]

Heh, yeah I suppose there are still some foot guns if you don't understand how things work.