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.ma...@intershop.de> > 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-ow...@postgresql.org [mailto: > pgsql-general-ow...@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 >
