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/
