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

From Adrian Klaver
Subject Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2
Date
Msg-id 201112300859.27115.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: duplicate key errors when restoring 8.4.0 database dump into 9.1.2  (Culley Harrelson <harrelson@gmail.com>)
List pgsql-general
On Friday, December 30, 2011 8:51:17 am Culley Harrelson wrote:
> 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.

Might want to try just dumping one table to make it a little easier.

>

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get the time zone offset
Next
From: "Cezariusz Marek"
Date:
Subject: How to get the time zone offset