On 5 March 2009 12:08, Thom Brown <thombrown@xxxxxxxxx> wrote:
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.
Thom2009/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
I'm bringing this thread back to life to see if there are any further thoughts on this. It would be nice to have a complete backup of a database cluster in custom format, and use pg_restore to restore an individual database in the same way that it can restore individual schemas and tables etc.
Thanks
Thom