From: s.chava@wcom.com
To: pgsql-admin@postgresql.org
Subject: pg_restore
Date: 6 Feb 2002 07:47:38 -0800
Message-ID: <66d229f1.0202060747.39b66049@posting.google.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s.chava@wcom.com
Subject: Re: pg_restore
In-Reply-To: <66d229f1.0202060747.39b66049@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox