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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to