Re: pg_dumpall custom format?

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(dot)Mamin(at)intershop(dot)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-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
>