Re: Upgrade from 7.2 to 7.4 - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Upgrade from 7.2 to 7.4
Date
Msg-id Pine.LNX.4.44.0311180444490.639-100000@peter.localdomain
Whole thread Raw
In response to Upgrade from 7.2 to 7.4  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
Chris Gamache writes:

> I'm trying to avoid having to install 7.3, dump 7.2 and reload 7.3, then
> install 7.4, dump 7.3 and install to 7.4 ... What's the chances of just using
> the 7.4 pg_dumpall on the 7.2 database and having it work 100% ?

Pretty good.  (At least no worse than going via 7.3.)  If it does not
work, it's cause for a bug report.

> Also, I recall that when upgrading from 7.2 to 7.3 there was something that had
> to be run to bootstrap the links between sequences and their respective tables
> such that if the table was dropped the sequence would go with it. What is that
> thing called? Is it included in the 7.4 tarball?

Yes, contrib/adddepend.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_restore and FK constraints with large dbs
Next
From: ow
Date:
Subject: Re: pg_restore and FK constraints with large dbs