On 10/22/07, cho <tobutaz@gmail.com> 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