About compress in pg_dump

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

Yep, I transfer backups files all the time with -Fc and never the
problem was rsync

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@aklaver.com

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