pg-restic – Postgres backups to S3/B2 (or any S3-compatible storage) using restic, in one small Docker container.

https://github.com/isriram/pg-restic

I needed Postgres backups at work and at home at the same time. I tried a few existing images, but after spending time setting them up I found they shipped an older pg_dump that couldn't back up newer Postgres versions. So I built my own.

It runs pg_dumpall on a cron schedule and streams it straight into a restic repo, so nothing touches local disk. You get encrypted, deduplicated snapshots (hourly dumps of a mostly unchanged DB take very little extra space), retention policies, and daily pruning. If the dump fails, no snapshot is saved. It ships pg_dumpall 18, so it can back up anything from 9.2 to 18.

I now run it in production at work, so I'll be keeping it up to date. I'm no expert, and this is the first time I'm doing something like this (putting something out there), so any feedback is welcome, especially from the database pros.

It's not fancy, but it's something I needed, and boy, I really needed something like this.