Don Barthel wrote:
> I've read about switchover here:
> http://slony.info/documentation/failover.html and it all makes sense.
> But I've also read that running Slony between two machines with
> different Postgresql version and different Slony versions is
> problematic.
>
> Let's say I have Postgresql 8.0.7 with Slony 1.1.5 (which I have) on a
> two node setup and I want to migrate to a spanking new server with the
> latest Postgresql with Slony, and let's say I want to use Slony beyond
> the migration.
>
> Can I run mismatched versions for the migration?
>
> What are the implications?
>
> Thanks, this list is great, and Slony is great.

Actually, that was one of the primary things Slony was designed to let 
you do, migrate.

Note that you need to pay attention to the same issues that you would if 
you were migrating from one version of pgsql to another.  I.e. read the 
release notes for the new version to spot any obvious things that might 
affect you.  One of the most common with 8.2.x is that checking of 
values for certain encodings are now checked more closely, so some data 
that might work in an older version of pgsql might not insert into 8.2.x