Thread: High Availability Cluster in Conjunction with PostGres

High Availability Cluster in Conjunction with PostGres

From
jeff@muttworks.com (Jeff Young)
Date:
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

Re: High Availability Cluster in Conjunction with PostGres

From
Oliver Korff
Date:
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