Re: About compress in pg_dump
Diego <mrstephenamell@gmail.com>
From: Diego <mrstephenamell@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>,
Edmundo Robles <edmundo@sw-argos.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2020-07-17T15:12:47Z
Lists: 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 > <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. >