On 5/18/07, Don Barthel <dbarthel at usedeverywhere.com> 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.
>

Different PostgreSQL versions is relatively trivial and supported under
slony. As another reply mentions, there may be issues with data which is
more closely checked in 8.2. However this isn't slony specific, and you'd be
crazy not to test your application against the newer version of before
implementing a major version upgrade.

Running different versions of slony between two machines is not supported.
It might be made to work, but it'd be a silly thing to do. Of course, you
don't need to upgrade slony at the same time you upgrade PostgreSQL. I'd
suggest you upgrade slony first (although personally I'd wait for 1.2.10),
and concurrently test your application against 8.2. Then subscribe your new
8.2 system and monitor it for a while until you're comfortable with running
it as a master. Finally, move the set and re-point your application during a
maintenance window.

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070529/=
8db760e4/attachment.htm