On 5 March 2009 12:08, Thom Brown <thombr...@gmail.com> 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. > > 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 >> > > 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