Tom Lane wrote on 28.10.2007 23:18:
Oh, I just twigged that you are using a plain-SQL dump file (that is,
you didn't specify -Fc or -Ft to pg_dump). For plain-SQL dumps you
should not use pg_restore at all; you feed those to psql.
While we are on the topic of pg_dump/pg_restore:
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?
Thomas
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
