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

Re: About compress in pg_dump

On 7/17/20 7:48 AM, Edmundo Robles 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

Re: About compress in pg_dump

Yep, I transfer backups files all the time with -Fc and never the problem was rsync On 2020-07-17 12:07, David G. Johnston wrote: On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles > wrote: To backup  a database  I do:  nice -n +19  pg_dump -Fc  database |

Re: About compress in pg_dump

On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles 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

About compress in pg_dump

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? if