| From: | s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava) |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | pg_restore |
| Date: | 2002-02-06 15:47:38 |
| Message-ID: | 66d229f1.0202060747.39b66049@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hey,
I have upgraded my pgostgresql from 7.1.2 to 7.1.3 as the pg_restore
is not working properly in 7.1.2
I took the database backup with pg_dump.
After upgrading to 7.1.3, I have restored the database with
pg_restore.
It is restoring , but giving the following error with sequences and
recovery is failing
Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR: mysequence.setval: you don't have permissions to set
sequence mysequence
Why it is giving the error that the perssion is not there. Actually, I
'm restoring from pgsql super user account.
Can anybody help me how to fix it. Thanks in advance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Trujillo | 2002-02-06 16:23:44 | Re: pg_restore |
| Previous Message | Tom Lane | 2002-02-06 15:47:17 | Re: starting log problems |