Search Postgresql Archives

Re: pg_dumpall custom format?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for the suggestion Marc.  It would still be nice to have the custom format included as an option though with pg_restore supporting it, just for consistency.

I will, however, follow your recommendation.

Thom

2009/3/5 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux