pg_restore

Поиск
Список
Период
Сортировка
От s.chava@wcom.com (Srinivasa Rao Chava)
Тема pg_restore
Дата
Msg-id 66d229f1.0202060747.39b66049@posting.google.com
обсуждение исходный текст
Ответы Re: pg_restore  (Manuel Trujillo <manueltrujillo@dorna.es>)
Re: pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: starting log problems
Следующее
От: Manuel Trujillo
Дата:
Сообщение: Re: pg_restore