Re: pg_restore errors

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