On 11-04-26 11:32 AM, Scott Marlowe wrote: > On Mon, Apr 25, 2011 at 6: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? > > It's how we upgraded from 8.1 to 8.3 smoothly a year or three ago. > I'd recommend updating slony to the latest version.
1.2.22 is the latest version of Slony that will work for what he is doing (if a 1.2.23 is ever needed/released I would assume that would continue to work as well). 2.0 or higher requires at least PostgreSQL 8.3 or higher. After he upgrades to 9.0 he could then upgrade to a more recent slony version. > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
