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