Thread

1. About compress in pg_dump

   Edmundo Robles <edmundo@sw-argos.com> — 2020-07-17T14:48:30Z

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

2. Re: About compress in pg_dump

   David G. Johnston <david.g.johnston@gmail.com> — 2020-07-17T15:07:31Z

   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.
   

3. Re: About compress in pg_dump

   Diego <mrstephenamell@gmail.com> — 2020-07-17T15:12:47Z

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

4. Re: About compress in pg_dump

   Adrian Klaver <adrian.klaver@aklaver.com> — 2020-07-17T20:18:09Z

   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
   
   
   
   

5. Re: About compress in pg_dump

   Adrian Klaver <adrian.klaver@aklaver.com> — 2020-07-17T20:21:51Z

   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