Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate Key violation on dump&reload using pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: Duplicate Key violation on dump&reload using pg_restore
Date
Msg-id 9782.1207350573@sss.pgh.pa.us
Whole thread Raw
In response to Duplicate Key violation on dump&reload using pg_restore  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-general
Tree view 
"Markus Wollny" <Markus.Wollny@computec.de> writes:
> I'm currently trying to migrate one of our databases from PostgreSQL 8.2.4 to PostgreSQL 8.3.1. I have worked around
theTsearch2 migration (we used the contrib module) without too much hassle, but find myself stuck at an unexpected
point- I get a duplicate key violation for the primary key on one of my tables: 

Maybe there actually is a duplicate key in the source DB --- have you
checked?  There were some bugs in early 8.2.x releases that could
possibly allow that to happen.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: too many LWLocks taken
Next
From: "Markus Wollny"
Date:
Subject: Re: Duplicate Key violation on dump&reload using pg_restore