On Mon, Apr 25, 2011 at 8:11 PM, Sam Choukri <[email protected]> wrote: > Hello, > > I am maintaining a pair of database servers on CentOS 5 running Posgtres > 8.1.18 and Slony 1.2.22 (1 master to 1 slave). I would like to upgrade the > database to Postgres 9.0, but I do not have the option of doing a standard > drop and restore. Therefore, I'd like to use Slony to replicate from 8.1 to > 9.0, then do a switchover. > > The release notes for Slony 1.2.22 says it added explicit support for > Postgres 9.0 so I'm cautiously optimistic I can do it. But is it a good idea? > Any gotchas I should be concerned about?
Your "gotchas" will generally have to do with changes in Postgres features. Notably, somewhere between 8.1 and 9.0, Postgres got quite a bit more strict about its handling of UTF-8, and a lot of people had headaches out of complaints of "invalid encoding". The issue got discussed pretty thoroughly here: <http://lists.slony.info/pipermail/slony1-general/2010-April/010596.html> > By the way, I could not find a search interface for the slony mail list > archives. Does one exist? We didn't put one in place; you can probably use search engines (e.g. - such as G**gl*)... _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
