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. If all you need is compression it's certainly easy enough: pg_dumpall | gzip >mydump.gz zcat mydump.gz | psql So the argument for doing more hinges around the extra flexibility of pg_restore to do selective restores and suchlike, and extending those features to behave sanely for multi-database dumps is not trivial. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
