From: Gnanakumar <gnanam@zoniac.com>
To: 'Kevin Grittner' <Kevin.Grittner@wicourts.gov>
To: pgsql-admin@postgresql.org
Cc: raghuchennuru@gmail.com
Subject: Re: DB Import Error...
Date: Thu, 7 Apr 2011 15:09:19 +0530
Message-ID: <002b01cbf507$ae806f60$0b814e20$@com> (raw)
In-Reply-To: <4D9AE575020000250003C2F4@gw.wicourts.gov>
References: <201104011542.p31Fg6L3025075@rs73.luxsci.com>
<006201cbf2d1$1ea55730$5bf00590$@com>
<4D99A788020000250003C21A@gw.wicourts.gov>
<002501cbf35d$54246310$fc6d2930$@com>
<4D9AE575020000250003C2F4@gw.wicourts.gov>
> You can install two different versions of PostgreSQL in different
> directories, or you can run pg_dump from the machine which is your
> conversion target. We do both. We always build from source, and we
> use a --prefix on configure which includes the version. For
> example:
I even tried out the recommended upgrade technique also. That is, installed
new version (9.0.3 in this case) of PostgreSQL in a different directory in
the same machine and used pg_dump of this latest version to access the old
database (running 8.2.3 in this case) to take a dump and then imported into
9.0.3. Still I'm facing *exactly* the same set of errors after importing (as
I was getting before).
ERROR: constraint "xxxx" for relation "xxxx" already exist
There are 260 occurrences of this type of error.
How do I resolve/fix this problem at this stage? Since this issue we're
facing is with our Production database dump, timely suggestions/advice/help
to resolve this are highly appreciated.
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: gnanam@zoniac.com, Kevin.Grittner@wicourts.gov, raghuchennuru@gmail.com
Subject: Re: DB Import Error...
In-Reply-To: <002b01cbf507$ae806f60$0b814e20$@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