Skip site navigation (1) Skip section navigation (2)

Re: postgresql clustering

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Daniel Duvall <the(dot)liberal(dot)media(at)gmail(dot)com>
Subject: Re: postgresql clustering
Date: 2005-09-28 23:36:50
Message-ID: 433B2912.3030302@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Daniel Duvall wrote:

> I've looked at PostgreSQL and EnterpriseDB, but I can't find anything
> definitive  as far as clustering capabilities.  What kinds of projects
> are there for clustering PgSQL, and are any of them mature enough for
> commercial apps?

As you well know "clustering" means all and nothing at the same time.
We do have a commercial failover cluster for provided by Redhat,
with postgres running on it. The Postgres is installed on both nodes and the
data are stored on SAN, only one instance of postgres run at time in one
of two nodes. In last 2 years we had a failure and the service relocation
worked as expected.

Consider also that applications shall have a good behaviour like "try" to
close the current connection and retry to open a new one for a while....

Regards
Gaetano Mendola


In response to

Responses

pgsql-hackers by date

Next:From: Ron PeacetreeDate: 2005-09-28 23:49:59
Subject: Re: [PERFORM] A Better External Sort?
Previous:From: Tatsuo IshiiDate: 2005-09-28 22:59:03
Subject: Re: enhanced pgbench

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group