Re: About compress in pg_dump - Mailing list pgsql-general

From Diego
Subject Re: About compress in pg_dump
Date
Msg-id 8531a4f3-15b1-4bea-4206-4a7944e82051@gmail.com
Whole thread Raw
In response to Re: About compress in pg_dump  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: About compress in pg_dump
List pgsql-general

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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: About compress in pg_dump
Next
From: "Hilbert, Karin"
Date:
Subject: Security Vulnerability on PostgreSQL VMs