Home > mailing lists

About compress in pg_dump - Mailing list pgsql-general

From	Edmundo Robles
Subject	About compress in pg_dump
Date	July 17, 2020 17:48:30
Msg-id	CAOXzpYBq98WKHje8B0ap7j4wap-BeNeovYWq4DyUxKFFZmr5WQ@mail.gmail.com Whole thread Raw
Responses	Re: About compress in pg_dump Re: About compress in pg_dump
List	pgsql-general

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. :)

Thanks for your help...

From: Paul Förster
Date: 17 July 2020, 17:10:15
Subject: Re: Where Do I Find...

From: "David G. Johnston"
Date: 17 July 2020, 18:07:31
Subject: Re: About compress in pg_dump