Re: High Availability Cluster in Conjunction with PostGres - Mailing list pgsql-general

From Oliver Korff
Subject Re: High Availability Cluster in Conjunction with PostGres
Date
Msg-id 200111081913.UAA15681@orion.eatserver.de
Whole thread Raw
In response to High Availability Cluster in Conjunction with PostGres  (jeff@muttworks.com (Jeff Young))
List pgsql-general
Hi Jeff,

have a look on
http://www.sgi.com/software/failsafe/
http://oss.sgi.com/projects/failsafe/mail.html

you can get it at:
ftp://ftp.suse.com/pub/projects/failsafe/

all you'll have to do is to write a shell script that does:
start Linux/PostgreSQL
stop Linux/PostgreSQL
monitor Linux/PostgreSQL (perhaps write data to a table and report success)

Advantages:
-good GUI
-on the market for some time
-still maintained by suse

Disadvatages:
-little bit poor docu

I can perhaps answer some questions, and I would really like to receive the
postgres-start-stop-monitor script!

Oliver
>I am evaluating the possibility of using Linux/PostgreSQL for an
>application that will require failover clustering for the database in
>the event of a processor failure or non-data hard drive failure.
>
>I am assuming the data is kept on a RAID Array that can be >picked up
>by another node in the cluster in the event of a failure in the Active
>node.
>
>Can anyone share experience with me.
>
>Jef
--
Do not expose your LaserWriter to fire or intense heat. -- Apple
LaserWriter manual

pgsql-general by date:

Previous
From: "Ivan Babikov"
Date:
Subject: Are 2-phase commited transaction available in Postgres?
Next
From: efreyre@qnet.com.pe
Date:
Subject: what is the error in the function?