On 10/22/07, cho <[EMAIL PROTECTED]> wrote: > > Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit: > > > We are setting up a new database system that is going to act as our > > central database. We are planning to have a Master/Slave setup, > > originally with one slave but there is a strong possibility of adding a > > second slave at our second site. We could run Mulit-Master, it just > > wasn't the original plan. (The original plan was MySQL log shipping). We > > do not want the possibility of loosing data in the event of loosing the > > master node so synchronous replication is preferable. We are using > > BLOBS, so the replication has to be able to handle that. The slave we > > want to have useable but it would be used for reporting only under > > normal usage. > > > If you want to use synchronous replication look at the link
http://www.postgresql.at/english/downloads_e.html this is an enhanced and tested version of pgcluster - it's open source you can use it it is also working on windows -- Ewald Geschwinde
