Re: Upgrading from 7.1

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Chris Travers <chris(at)travelamericas(dot)com>
Cc: "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:27:16
Message-ID: 20050728002716.GU1832@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 27, 2005 at 05:13:01PM -0700, Chris Travers wrote:
> Thomas F. O'Connell wrote:
>
> >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.

This problem is solved in 8.0's pg_dump. Not sure if 7.1 has enough
information in catalogs to make the algorithm run correctly -- I wonder
if pg_depend is needed, because AFAIR there was no pg_depend in 7.1.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"The Gord often wonders why people threaten never to come back after they've
been told never to return" (www.actsofgord.com)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-28 00:28:10 Re: transaction timeout
Previous Message Alvaro Herrera 2005-07-28 00:25:58 Re: GUID for postgreSQL