Re: [GENERAL] PostgreSQL on a Cluster

On Sun, Apr 13, 2003 at 11:31:03PM +0300, Devrim GUNDUZ wrote:
> This is what we are planning:
>
>
>         +---------------+
>         +   Storage    +
>         +    Area    +
>         +   Network    +
>         +---------------+
>             +
>             +
>         -----------------
>         |        |
>     Master Server       2nd Master
>     with eRServer        Server
>               for load balancing

> So let's say we want to do some operation on the database, located at SAN.
> When the 1st server wants to update a row, it will lock it. What happens
> when the second server wants to access the same row? Does 1st server
> "broadcast" that it has locked the row?

This suggests you misunderstand how eRServer and PostgreSQL work.
There's no such thing as a "2d master".  It's impossible (well,
unless the eRServer folks have done something they haven't told the
rest of us about).

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110