pg_restore
| От | s.chava@wcom.com (Srinivasa Rao Chava) |
|---|---|
| Тема | pg_restore |
| Дата | |
| Msg-id | 66d229f1.0202060747.39b66049@posting.google.com обсуждение исходный текст |
| Ответы |
Re: pg_restore
Re: pg_restore |
| Список | 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
В списке pgsql-admin по дате отправления: