Re: High Availability Cluster in Conjunction with PostGres

From: Oliver Korff <xynyx(at)xynyx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: jeff(at)muttworks(dot)com, michael(dot)meskes(at)credativ(dot)de
Subject: Re: High Availability Cluster in Conjunction with PostGres
Date: 2001-11-08 19:13:27
Message-ID: 200111081913.UAA15681@orion.eatserver.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2001-11-08 19:13:33 Re: PSQL anc compile errors
Previous Message qradius 2001-11-08 18:56:45 Problem with function