Re: Retoring non-administrative user databases

>>>What am I missing?
>>>
>>>
>>A reproduceable test case.
>>
>>
>>
It is reproduceable for him Peter.

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 peter_e(at)gmx(dot)net
>>
>>
>>
>
>???
>
>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 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL.Org - Editor-N-Chief - http://www.postgresql.org