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@sw-argos.com 
>> <mailto:edmundo@sw-argos.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.klaver@aklaver.com