Postgres Clustering Options

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Clustering Options
Date: 2009-11-11 17:28:36
Message-ID: 20091111172836.GA24289@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to meet a very high uptime requirement in a high performance environment.

to do this we will need to have some form of cluster for our databases

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)

Log shipping between that cluster and a single PG Instance off site.

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?

Thanks

Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2009-11-11 17:35:35 Re: Postgres Clustering Options
Previous Message informatica 2009-11-11 16:20:17 Re: Will PostgreSQL 8.4 allow having different encoding databases on a same PostgreSQL server ?