Re: postgreSQL on NAS/SAN?

On Tue, Jun 17, 2003 at 15:41:45 +0200,
Daniel Seichter <daniel(at)dseichter(dot)de> wrote:
> Hello Scott,
>
> > Are you looking more for failover, load balancing, hot
> > spare?
> I am looking for a hot spare, so if one server crashed, the second will
> "spare" it, because if this database will be down (down is meant for longer
> than 2 hours) more than two other databases will not continue working (they
> could continue working, but without new data, so it will be senseless).

Once the orignal postmaster has stopped running (say because its server
died) you could run a different postmaster (on say another server) and
access the same data on your storage system. But if you do this you
will want some sort of safety system so that two postmasters can't
accidentally run at the same time. The normal interlock won't work for you
because it keeps a PID file and checks to see if the pid in that file (if any)
is still running. That doesn't work accross servers.