On Wed, Feb 25, 2009 at 3:20 PM, Avi Blackmore <support@xxxxxxxxxxx> wrote: > Hi folks, > > I'm working on migrating our database cluster from PostgreSQL 8.1 to 8.3. > I'm following the "dump and restore, then use Slony to replicate" > procedure, to minimize downtime. The problem is, the new 2.0 version of > Slony-I does not support anything prior to 8.3, so I have to install > different versions of Slony-I. Not sure that will work. or if it does if it will work properly. > My question is, is this even feasible? Or would I be better off installing > Slony-I 1.x on my 8.3 cluster, and then upgrading it after the migration? Ding! That's what I'd do. > I ask first because I am extremely skittish about experimenting with a > production database cluster. :-) I'd make a backup, restore it to a test server, and start testing. I am pretty protective of my production servers as well. Testing is the only way to see your problems ahead of time. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
