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
