From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | Daniel Seichter <daniel(at)dseichter(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgreSQL on NAS/SAN? |
Date: | 2003-06-17 14:52:06 |
Message-ID: | Pine.GSU.4.44.0306170750190.11938-100000@eskimo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There is a system which uses your serial port so that if server B detects
server A goes down, it will send a signal over the serial port which
disconnects server A's power supply. That way, server B never
"accidentally" takes over for server A when in fact server A is still
running. I don't remember where these are sold, but they were mentioned
in the MissionCriticalLinux system documentation.
Jon
On Tue, 17 Jun 2003, Bruno Wolff III wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2003-06-17 15:03:52 | Re: full featured alter table? |
Previous Message | Stephan Szabo | 2003-06-17 14:48:06 | Re: adddepend and partial indexes |