Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'Kevin Grittner'" <Kevin.Grittner@wicourts.gov>,
	<pgsql-admin@postgresql.org>
Cc: <raghuchennuru@gmail.com>
References: <201104011542.p31Fg6L3025075@rs73.luxsci.com>
	<006201cbf2d1$1ea55730$5bf00590$@com>
	<4D99A788020000250003C21A@gw.wicourts.gov>
	<002501cbf35d$54246310$fc6d2930$@com>
	<4D9AE575020000250003C2F4@gw.wicourts.gov>
In-Reply-To: <4D9AE575020000250003C2F4@gw.wicourts.gov>
Subject: Re: DB Import Error...
Date: Thu, 7 Apr 2011 15:09:19 +0530
Organization: Zoniac Software Private Limited
Message-ID: <002b01cbf507$ae806f60$0b814e20$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcvzoJ+1IBzpjQYUR/mntcRu5XBQsgBY+1/Q
Content-Language: en-us

> 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.