From: | Scott Frankel <leknarf(at)pacbell(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_restore errors |
Date: | 2005-11-11 00:21:41 |
Message-ID: | B5A51377-58AE-4A72-A2A6-B291387E25B0@pacbell.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | snacktime | 2005-11-11 00:58:26 | Re: Dynamic web sites with PostgreSQL |
Previous Message | Bob Pawley | 2005-11-10 23:56:18 | Re: Where |