<div class="gmail_quote">On Mon, Apr 25, 2011 at 8:11 PM, Sam Choukri <span dir="ltr"><<a href="mailto:sam@eventful.com">sam@eventful.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Therefore, I'd like to use Slony to replicate from 8.1 to 9.0, then do a switchover.</blockquote></div><div><br></div>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.<div>
<br></div><div>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.</div><div><br></div><div>There may be other issues. You should research the release notes of every version between 8.1.x and 9.0.4</div>
<div><br></div><div>As far as slony is concerned, this is one of the use cases it was designed to handle, so will do its job well.</div>