Re: Postgres Clustering Options

On Wed, Nov 11, 2009 at 7:28 PM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:

> What I plan on doing is:
>
> Postgres installed on a Cluster configured in active/passive (both pointing
> to the same SAN
> (If PG or the OS fails we trigger a failover to the passive node)
>
> Is this a common/reccomended method of handling clusterin with Postgres?
> google searches
> basically point to using a replication based solution, which i don't think
> would meet my
> performance demands.
>
> Does anyone have expereince with this or a similar setup that they could
> share with me?
>

We have done a setup like this with Red Hat Cluster Suite.

We are quite happy with the setup in general, and it has been working well
even in 'unexpected circumstances' (power outages etc). The only thing I'd
change in this setup if I could is the cluster software: RHCS is not mature
enough and it seems every release contains new critical bugs, and sometimes
even mission-critical components such as quorum disk do not work after an
upgrade.

Regards

Mikko