Re: Upgrading from 7.1

From: Chris Travers <chris(at)travelamericas(dot)com>
To: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrading from 7.1
Date: 2005-07-28 00:13:01
Message-ID: 42E8230D.5080208@travelamericas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas F. O'Connell wrote:

>
>
> 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?
>
I seem to remember encountering an issue some time ago with pg_dump
dumping tables in an order that prevented them from being reloaded.

The solution was to specify the order of the tables in the commandline.

Hope this helps.
Chris Travers
Metatron Technology Consulting

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Tillotson 2005-07-28 00:16:08 Re: transaction timeout
Previous Message Dr NoName 2005-07-28 00:12:46 Re: transaction timeout