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

Re: postgresql clustering

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: Daniel Duvall <the(dot)liberal(dot)media(at)gmail(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql clustering
Date: 2005-09-29 00:37:50
Message-ID: 433B375E.4050909@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Gaetano Mendola wrote:

>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?
>>    
>>

Are you looking for clustering or replication? There are two very 
popular replication
solutions: Slony-I and Mammoth Replicator.

Slony-I is an external replication solution, Mammoth Replicator is a 
complete
PostgreSQL + Replication solution.

Sincerely,

Joshua D. Drake

>
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings
>  
>


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


In response to

pgsql-hackers by date

Next:From: Daniel DuvallDate: 2005-09-29 00:37:51
Subject: Re: postgresql clustering
Previous:From: Ron PeacetreeDate: 2005-09-29 00:25:31
Subject: Re: [PERFORM] A Better External Sort?

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