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 pass  gzip options  to compress in pg_dump?
>
> if not   I will use :
> nice -n +19  pg_dump -Fc -Z 0 database | nice -n +19 gzip --rsyncable
> -nc >  database.dump
> but I dont want to do that. :)

Do you need the custom format on the other end?

Or can you just use the plain format dump and pipe that to gzip with
appropriate options?

You will then need to use psql to do the restore though.

>
> Thanks   for your help...
>
> --
>

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