Re: pg_restore

Tom Lane wrote on 29.10.2007 00:55:
> Thomas Kellerer <spam_eater@gmx.net> writes:
>> Why is it, that pg_dump can use a compressed output directly but pg_dumpall is
>> always using a SQL (i.e. "plain text") output?
>
> The custom and tar formats are not designed to support data from more
> than one database.  At some point somebody should probably try to
> improve that situation, but it's not immediately obvious what the
> feature ought to look like.

OK, thanks


> If all you need is compression it's certainly easy enough:
>
>     pg_dumpall | gzip >mydump.gz

That's what I'm currently doing ;)


Thanks