On Mon, 17 May 2004 18:13:36 +0100 Richard Huxton <dev@archonet.com> wrote: > Jeff wrote: > > Slony-I is an async replication system. > > It is pre-beta, but already it works very well. I'm using it in > > production with 5 slaves! > > > > http://gborg.postgresql.org/projects/slony1/ > > Any chance of a quick review - installation issues, experience in use? > It is a little light on the documentation front at the moment, when I get some time I'll be writing some. But I found the test scripts gave enough info (along with what documentation was there) to get going. I ran into a couple problems which I fixed (an issue with multiple replication sets and another thread locking issue that tickled a kerberos issue (Which actually was fixed in 7.5's libpq)). Its now working fine in production. We're replicating about 150k insert/update/deletes every hour. The author of slony is very nice and willing to help out. We have an irc channel on irc.freenode.net - #slony where we can try to help if you have problems. I must say, it does work better than eRserver which has a nasty habit of running into java errors and dying (and dying again when restarting). (encountering > 7bit ascii in a sql_ascii db causes jdbc to die.. although libpq, etc. have no issues with the 7bit ascii) -- Jeff Trout <jeff@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)