Re: pg_restore errors

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
>