Re: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110