On 6/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm disappointed because SLONY-II has not been released yet to support multi-master replication!
I wouldn't pin all my hopes on a project still under development. (For me, personally, add the fact that Slony-I still has not solved single-master replication in a way that doesn't burden the developer/DBA with lots of unnecessary extra maintenance; I am not counting on its developers to fix this issue in Slony-II.) In the meantime, Cybertec (http://www.postgresql.at/, an Austrian company) just announced a commercial synchronous multimaster replication product based on 2-phase commit. It's expensive, and I can't speak for its maturity, and it may or may not scale as well as the projected Slony-II design, but the setup seems dead simple, and from the docs I have found it seems to transparently replicate schema changes, unlike Slony-I. So that's something. Alexander. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
