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.klaver@xxxxxxxxxxx
