Re: pg_dumpall custom format?

On 5 March 2009 12:08, Thom Brown <thombrown(at)gmail(dot)com> wrote:

> 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
>>
>
>
I'm bringing this thread back to life to see if there are any further
thoughts on this. It would be nice to have a complete backup of a database
cluster in custom format, and use pg_restore to restore an individual
database in the same way that it can restore individual schemas and tables
etc.

Thanks

Thom