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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)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