Incremental backups of Postgres
So we want to set up an incremental backup system for our PostgreSQL instance. Right now we are only taking full dumps of our PostgreSQL instance and end up wasting a lot of disk space.
We are looking into restic and pgbackrest for the incremental backups but not sure what to use.
Anyone using restic or pgbackrest for Postgres backup? Any other tool we should consider?
Honestly I don't know pgbackrest yet. But I can tell you that streaming a pg_dump | restic -r /srv/restic-repo backup --stdin is quite simple.
( https://restic.readthedocs.io/en/stable/040_backup.html#reading-data-from-stdin )
Other than that, I hear good things about barman https://www.pgbarman.org/
Thanks, we explore restic a bit more and it works like a charm.