Re: Cluster Database - Mailing list pgsql-admin

From Chris Miles
Subject Re: Cluster Database
Date
Msg-id 20021124005130.A18722@psychofx.com
Whole thread Raw
In response to Cluster Database  ("Al-Karim Bhamani (LCL)" <ABhaman@ngco.com>)
List pgsql-admin
On Thu, Nov 21, 2002 at 11:17:41AM -0500, Al-Karim Bhamani (LCL) wrote:
> Can Postgresql run in an clustered environment
> as Oracle runs as parallel server or RAC in 9i.

Depends what you mean by 'clustered'.  We run PostgreSQL in
a HA environment (which some might call a 'cluster') with
2 PostgreSQL servers running their own PostgreSQL instance,
but with the ability to automatically failover to their
partner using Heartbeat (from linux-ha.org).

The data lives on NFS servers and so is available to both
hosts.

Consider this a "poor man's HA cluster", altho it works
reasonably well, and all software elements are free.

Cheers,
CM

--
Chris Miles
chris_pg002@psychofx.com

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: crash help, pgsql 7.2.1 on RH7.3
Next
From: Egon Reetz
Date:
Subject: Dropping Foreign Key without recreating table