Re: pg_dumpall custom format?

["Marc Mamin" <M.Mamin@xxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Thom Brown
Sent: Thursday, March 05, 2009 11:53 AM
To: pgsql general
Subject: 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