Re: postgresql clustering

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/