Re: COPY errors when trying to convert from 7.4.19 to 8.3.1 - Mailing list pgsql-admin

From Tom Lane
Subject Re: COPY errors when trying to convert from 7.4.19 to 8.3.1
Date
Msg-id 25101.1209674048@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY errors when trying to convert from 7.4.19 to 8.3.1  (Geoffrey <lists@serioustechnology.com>)
List pgsql-admin
Geoffrey <lists@serioustechnology.com> writes:
> Shane Ambler wrote:
>> You would have two choices - clean up the data in 7.4 before the export
>> or clean up after the import and before the fk constraints are added.

> The latter is likely the plan.  The primary concern is that we don't
> lose any data.

There seem to be two possibilities: either the data was actually
inconsistent in the 7.4 database (in which case it would be good to
find out how it got that way), or the data is fine but the pg_dump
script tried to do the ALTER ADD CONSTRAINT too soon (in which case
it would be good to find out why pg_dump got confused about that).
In either case I'm hoping you still have the 7.4 installation available
for inspection ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Geoffrey
Date:
Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1
Next
From: Tom Lane
Date:
Subject: Re: 8.1.8 autovacuum missing databases