Re: pg_restore - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: pg_restore
Date
Msg-id fg5947$2bp$1@ger.gmane.org
Whole thread Raw
In response to Re: pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [HACKERS] WAL archiving idle database
Next
From: "bharat u"
Date:
Subject: reg. rewrite rules