Re: How to get a more RSYNC compatible output of pg_dump?

On Mon, May 16, 2022 at 09:56:34AM +0200, Thorsten Schöning wrote:
> Is that simply the way it is or are there some optimizations possible
> when using pg_dump? Am using Postgres 11 and don't see anything which
> seems to help in this use-case.

What I'd suggest:
1. Use -Fd, to have each table separately
2. Use -Z0 to avoid normal compression
3. Use `gzip --rsyncable` on the data, to make the backup smaller for
   transmit (though you will need to unpack it to restore), or play with
   other compressors, like xz

depesz