Skip site navigation (1) Skip section navigation (2)

Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2

From: Culley Harrelson <harrelson(at)gmail(dot)com>
To: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Date: 2011-12-30 16:51:17
Message-ID: CAAPtAvQqwd0aCkt0pbMyJjmFMxGXM9CxB_7db27Nsps8+yuu8A@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)d(dot)sera(at)gmail(dot)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.
>

In response to

Responses

pgsql-general by date

Next:From: Adrian KlaverDate: 2011-12-30 16:57:21
Subject: Re: How to get the time zone offset
Previous:From: Carlos MennensDate: 2011-12-30 16:50:57
Subject: Dated Version of PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group