From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: version upgrade |
Date: | 2004-08-31 22:16:55 |
Message-ID: | 200408311516.55143.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-08-31 22:23:47 | Re: version upgrade |
Previous Message | markir | 2004-08-31 21:44:37 | Re: [pgsql-hackers-win32] Testing needed for recent |