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