Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall custom format? - Mailing list pgsql-general

From Marc Mamin
Subject Re: pg_dumpall custom format?
Date
Msg-id C4DAC901169B624F933534A26ED7DF311D540F@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to pg_dumpall custom format?  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view
Hello,
 
you can first pipe the output of pg_dump to a compression tool:
 
pg_dump..... | gzip > file.
 
instead of gzip, I'm using pigz which is faster thanks multithreading.
 
HTH,
 
Marc Mamin
 
 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thom Brown
Sent: Thursday, March 05, 2009 11:53 AM
To: pgsql general
Subject: [GENERAL] pg_dumpall custom format?

Hi,

I noticed that while pg_dump can output a custom format, effectively compressing the output, pg_dumpall doesn't.  Is there a reason for this?  And is there a way to get pg_dumpall to compress it's output?

Thanks

Thom

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: pg_dumpall custom format?
Next
From: Ashish Karalkar
Date:
Subject: PostgreSQL template for cacti