Re: About compress in pg_dump

On 7/17/20 8:12 AM, Diego wrote:
> Yep, I transfer backups files all the time with -Fc and never the
> problem was rsync

Using --rsyncable with gzip really helps if you rsync the compressed
file to somewhere else it exists. It greatly reduces the amount of data
sent for files that a do not have a massive amount of changes between syncs.

>
> On 2020-07-17 12:07, David G. Johnston wrote:
>> On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles <edmundo(at)sw-argos(dot)com
>> <mailto:edmundo(at)sw-argos(dot)com>> wrote:
>>
>> To backup  a database  I do:
>>  nice -n +19  pg_dump -Fc  database | nice -n +19 gzip --rsyncable
>>   -nc >  database.dump
>>
>> If -Fc  option  is compressed  by default  I dont need gzip the
>> backup,  but I need pass --rsyncable and -n options.
>>
>> How can  I pass  gzip options  to compress in pg_dump?
>>
>>
>> pg_dump isn't using the gzip program, it's just performing compression
>> per the gzip compression specification, and doesn't provide those two
>> features to control it's processing (or any features beyond what's
>> documented on the pg_dump reference page).
>>
>> David J.
>>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com