From: Manuel Trujillo <manueltrujillo@dorna.es>
To: Srinivasa Rao Chava <s.chava@wcom.com>
Cc: pg-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_restore
Date: 06 Feb 2002 17:23:44 +0100
Message-ID: <1013012624.902.12.camel@klingon> (raw)
In-Reply-To: <66d229f1.0202060747.39b66049@posting.google.com>
References: <66d229f1.0202060747.39b66049@posting.google.com>
On Wed, 2002-02-06 at 16:47, Srinivasa Rao Chava wrote:
> 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
Hi.
I'm not any guru, but I think if you make the pg_dump/pg_restore with
the -x (whitout acl's), and -O (whitout owner) an, finally, -i
(ignore-version), will possible to make this backup (I think).
Have a nice day ;-)
TooManySecrets
--
Manuel Trujillo manueltrujillo@dorna.es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864
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: manueltrujillo@dorna.es, s.chava@wcom.com
Subject: Re: pg_restore
In-Reply-To: <1013012624.902.12.camel@klingon>
* 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