Scott Frankel <leknarf(at)pacbell(dot)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