It is reproduceable for him Peter.What am I missing?A reproduceable test case.
Keith could you provide a little more information?
Who is the user doing the dump? Who is the user doing the restore? Are these users superusers?
Either way, my suggestion would be to dump the schema only, restore the schema only.
Then dump the data only, and restore the data only.
7.1.3 has some oddities that don't always make a clean restore to a newere version (at
leat not 7.3 series)
Sincerely,
Joshua Drake
-- Peter Eisentraut [EMAIL PROTECTED]
???
Ok, lets try the question this way...
What is a method of dumping and restoring a complete database cluster when that cluster contains users that are NOT allowed to create databases.
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC Postgresql support, programming, shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
