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
Are you looking for clustering or replication? There are two very
solutions: Slony-I and Mammoth Replicator.
Slony-I is an external replication solution, Mammoth Replicator is a
PostgreSQL + Replication solution.
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....
>---------------------------(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 Duvall||Date: 2005-09-29 00:37:51|
|Subject: Re: postgresql clustering|
|Previous:||From: Ron Peacetree||Date: 2005-09-29 00:25:31|
|Subject: Re: [PERFORM] A Better External Sort?|