On Mon, Apr 25, 2011 at 8:11 PM, Sam Choukri <sam at eventful.com> wrote:

> Therefore, I'd like to use Slony to replicate from 8.1 to 9.0, then do a
> switchover.


Be sure to test your application(s) against the 9.0 version before you do
this. There are some minor incompatibilities you will need to address.
 Mostly these are changes in implicit casting of some types (such as strings
to integers) in certain cases.

Also, if you have utf-8 encoding, beware that newer postgres versions are
more strict than some of the older ones.  I'm not sure if 8.1 is as strict
as 9.0.

There may be other issues. You should research the release notes of every
version between 8.1.x and 9.0.4

As far as slony is concerned, this is one of the use cases it was designed
to handle, so will do its job well.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110426/d1feb8c0/attachment.htm