Tom Lane wrote on 29.10.2007 00:55:
Thomas Kellerer <spam_eater@xxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
