PostgreSQL clustering (shared disk)

From: "Mikko Partio" <mpartio(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL clustering (shared disk)
Date: 2007-08-16 06:42:01
Message-ID: 2ca799770708152342o1f92b63r26d70be3fb71936f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I have a mission to implement a two-node active-passive PostgreSQL cluster.
The databases at the cluster are rather large (hundreds of GB's) which opts
me to consider a shared disk environment. I know this is not natively
supported with PostgreSQL, but I have been investigating the Red Hat Cluster
Suite with GFS. The idea would be that the cluster programs with gfs (and HP
ilo) would make sure that only one postmaster at a time would be able to
access the shared disk, and in case the active node fails the cluster
software would shift the services to the previously passive node. What I'm
pondering here is that is the cluster able to keep the postmasters
synchronized at all times so that the database won't get corrupted.

Is there anyone on the list that has seen such configuration, or, even
better, implemented it themselves? I found a small document by Devrim Gunduz
describing this scenario but it was rather scant on details.

If shared disk is definitely out of the question, the fallback plan would be
to use drbd and linux-ha.

Regards

MP

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy 2007-08-16 06:47:15 8.3 performance
Previous Message bhyuan 2007-08-16 06:40:28 UTF-8 encoding problem