-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 26/04/2011 02:11, Sam Choukri a écrit :
> 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? 

Yes, Slony does allow you to do seach an upgrade.
As you are already using Slony, you know what it can do and what it can't.
Doing a replication from 8.1 to 9.0 does not bring you any new gotcha.

> 
> By the way, I could not find a search interface for the slony mail list archives. Does one exist?

google :-)

Regards,

- -- 
Stéphane Schildknecht
Loxodata
Contact régional PostgreSQL

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk22Ws8ACgkQA+REPKWGI0H4tACgvF+D8mmnfoS6W4cLm82cSlaG
aQAAniYHMz5kvesK6fWe29g1LE/M5/0d
=B5mf
-----END PGP SIGNATURE-----