Re: Cluster/Replication

On 10/22/07, cho <tobutaz(at)gmail(dot)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