From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall custom format? |
Date: | 2009-03-05 11:08:10 |
Message-ID: | bddc86150903050308w5447dc84kbcb09b97859e7ee1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ashish Karalkar | 2009-03-05 11:20:11 | PostgreSQL template for cacti |
Previous Message | Marc Mamin | 2009-03-05 11:02:56 | Re: pg_dumpall custom format? |