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@xxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
