Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2 - Mailing list pgsql-general

From Culley Harrelson
Subject Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Date
Msg-id CAAPtAvQqwd0aCkt0pbMyJjmFMxGXM9CxB_7db27Nsps8+yuu8A@mail.gmail.com
Whole thread Raw
In response to Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Responses Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
List pgsql-general
This is just the first of many duplicate key errors that cause primary key creation statements to fail on other tables.  I grepped for the key but it is hard to tell where the problem is with 888 matches.

I will try pg_dump --inserts.  It is a 17G file with copy statements so... this should be interesting.  And take a long time.



On Fri, Dec 30, 2011 at 8:20 AM, Bèrto ëd Sèra <berto.d.sera@gmail.com> wrote:
Hi!
 
Are you sure there is just one record? 

What happens if you grep the backup file for "653009"?

If you do have more than one such record, the quickest way out is to manually clean it.

Bèrto
 
--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Dated Version of PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: How to get the time zone offset