[Belphemur]

I've been using Borgmatic for this.

It does everything, uses pg_dump under the hood, and adds the output as files for Borg.

Borg then takes care of encryption, incremental and also bit rot. Best solution ever in my book.

Also you can directly restore the db with Borgmatic.

https://torsion.org/borgmatic/docs/how-to/backup-your-databa...

[gkhartman]

This looks great. When working in smaller teams, there's a lot of pushback when the suggestion of adding a new tool comes up, mostly due to the learning overhead involved. This might be just what we need, since it leverages existing tools many are familiar with already. Thanks for the suggestion.

[BonoboIO]

Thanks for the tip. Maybe this will replace my shell automysqlbackup script.