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/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
