Voila, 2. Executed as superuser and, yes, no errors.
Thanks again!
Scott
On Nov 10, 2005, at 3:51 PM, Tom Lane wrote:
> Scott Frankel <leknarf@pacbell.net> writes:
>
>> After upgrading from postgres 7.x.x to 8.1.0, my database restore
>> produces the following error msgs.
>>
>
>
>> SCHEMA public postgres
>> pg_restore: [archiver (db)] could not execute query: ERROR: must be
>> owner of schema public
>> Command was: COMMENT ON SCHEMA public IS 'Standard public
>> schema';
>> pg_restore: WARNING: no privileges could be revoked
>> pg_restore: WARNING: no privileges were granted
>>
>
> Apparently you're not running the restore as a database superuser?
>
> Those particular messages can be ignored, since public presumably
> exists
> (and is commented) already. If you see any others then you might want
> to worry.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>