Re: version upgrade

Andrew,

> If I were loony enough to want to make an attempt at a version updater
> (i.e. migrate a
> 7.4 database to 8.0 without an initdb), any suggestions on where to
> poke first? Does a
> catalog/list of system catalog changes exist anywhere? Any really gross
> problems immediately
> present themselves? Is dusting off pg_upgrade a good place to start, or
> is that a dead end?

Join the Slony project? Seriously, this is one of the uses of slony. All
you'd need would be a script that would:

1) Install PG 8.0 to an alternate directory;
2) Start 8.0;
3) install Slony on both instances (the 7.4 and the 8.0);
4) make 7.4 the "master" and start replicating
5) when 8.0 is caught up, stop 7.4 and promote it to Master
6) turn off Slony.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco