Re: Upgrading from 7.1 - Mailing list pgsql-general

From Thomas F. O'Connell
Subject Re: Upgrading from 7.1
Date
Msg-id BC442DD0-D073-4372-9225-F3E395F4882F@sitening.com
Whole thread Raw
In response to Re: Upgrading from 7.1  ("Jonathan Villa" <jvilla@innovativesource.net>)
Responses Re: Upgrading from 7.1
List pgsql-general
On Jul 27, 2005, at 3:43 PM, Jonathan Villa wrote:

> My approach will be/has been as follows:
>
> I've used pg_dump of 7.4 to do
>
> pgsql-7.4 $>pg_dump --schema-only dbName > schema.sql
>
> Aside from some tweaking, the import seemed to work fine.
>
> Now, I'm attempting the following
>
> pgsql-7.4 $> pg_dump --data-only --inserts dbName > data.sql
>
> and when I attempt an import, I get
>
> ERROR:  insert or update on table "doc_data" violates foreign key
> constraint
> "docdata_languageid_fk"
> DETAIL:  Key (language)=(1) is not present in table
> "supported_languages".
>
> Regarding the violations of the foreign key contraints, I've been
> able to
> export/import from 7.1 to 7.1 ok.
>
> When I was doing the schema.sql import, I did receive a lot of
> messages regarding
> implicit indexes being created?  Is this something I should be
> worried about?
>
> Reason I'm not moving to 8.0 is because the application I'm trying
> to get upgraded
> does not give it it's seal of approval.
>
>
> -Jonathan

Jonathan,

The implicit indexes are no big deal; they're just a sign of indexes
getting created by PRIMARY KEYs on your tables.

I'm not sure why you're getting errors. Is there a reason you did the
schema dump separately from the data dump rather than a monolithic
dump/restore?

Once you get your data import working, you might want to check out
contrib/adddepend, though, since you're coming from a pre-7.3 database.

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: GUID for postgreSQL
Next
From: Tony Caduto
Date:
Subject: Re: GUID for postgreSQL