PostgreSQL and HA?

Thomas K���hler wrote:
-- Start of PGP signed section.

Hi,
Just having read http://developer.postgresql.org/todo.php - seems
like quite a few features for high availibility are still
missing. So - what's the recommended way to get some kind of HA
up and running using PostgreSQL at the moment? How much HA will I be
able to get?

You can get master/slave replication from /contrib/dbmirror or
/contrib/rserv.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

You can do HA from the OS level:

Have a SCSI disk array shared between two computers
Use a journalling filesystem on this array
Have a "serial kill switch"
Have a program that checks if each server is alive.
If the primary goes down, the secondary will:
a) Shut off the power to the primary
b) Mount the disks
c) Start necessary services
d) Do IP takeover of the main server's IP address

The "serial kill switch" is necessary when disk arrays are being shared,
so that two computers don't inadvertantly access the disk array at the
same time. That way, if the problem is just a comm problem between the
computers, the primary will be killed off completely, and not be able to
cause problems.

There are packages that automate parts of it, and if this is of interest
to you, I can find some good articles on it. Personally, I've found that
using a stable operating system, hardware with hotswappable drivers/power
supplies, power coming in from two different circuits, and a UPS, will
give you almost as much uptime, with less difficulty and cost.

Jon

On Mon, 25 Aug 2003, Thomas [iso-8859-1] K�hler wrote: