Immich backup doubts
https://immich.app/docs/guides/template-backup-script/
The presently recommended backup method (for the database) is to use pg_dumpall to create a logical SQL-query based backup from the PG database. And then use borgbackup to deduplicate this and back it up somewhere.
Won't de-duplication fail to work on this pg_dumpall query file?
I'm assuming that there's no regular ordering for these files, and that even small DB changes might lead to the dump being changed in its middle. Then the whole file (or at least the contents after the edit) will appear to be new to borg.
(I'm aware that borg does de-duplication block-wise. I'm guessing this is how it works for text files)
Potentially a 100s of MB sized dump could look new with a few lines of DB changes, right?
The presently recommended backup method (for the database) is to use pg_dumpall to create a logical SQL-query based backup from the PG database. And then use borgbackup to deduplicate this and back it up somewhere.
Won't de-duplication fail to work on this pg_dumpall query file?
I'm assuming that there's no regular ordering for these files, and that even small DB changes might lead to the dump being changed in its middle. Then the whole file (or at least the contents after the edit) will appear to be new to borg.
(I'm aware that borg does de-duplication block-wise. I'm guessing this is how it works for text files)
Potentially a 100s of MB sized dump could look new with a few lines of DB changes, right?
