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.Mamin@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
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