On August 26, 2004 02:07 pm, Brian Hirt wrote:
> i've seem people mention that slony can be used to migrate between
> releases, and i want to start looking at a migation plan from 7.4 to 7.5
> so that we don't have downtime during our upgrade.
>
> I haven't been able to find out how to do this yet.  Will this be a
> pretty straight forward process, or are there going to be lots and lots
> of mantual steps involved.
>
> can someone point me to a howto, or similiar documentation that explains
> this process?

While I haven't seen any docs that specificly state how to do this  I can give 
you a quick overview of the steps.

You create a set that has all the objects you wish to replicate in it (see the 
basic master slave howto for an example)   the 7.4 DB is the origin, 7.5 the 
subscriber.  Subscribe the set, wait for replication to catch up.. once it's 
all caught up issue a switchover, and then you can uninstall node....

Keep in mind that Slony is not a network managemnet system, so it doesnt; do 
things like change IP addresses of servers and all that stuff....


This is a 10,000 foot overview, and I recommend you try it on a test set first 
untill you are confident in it's usage.. (feel free to document your steps 
and submit it to the mailing list to help others) 


-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com