From: Rodrigo Hjort <rodrigo.hjort@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgresql Replication High Availability
Date: Sat, 3 Dec 2005 01:32:20 -0200
Message-ID: <731083980512021932v7b3236cdg@mail.gmail.com> (raw)
We're on the same situation.
--> PGCluster
Actualy, we installed and tested PGCluster on UML (User Mode Linux)
environment and real distributed stations. There were a lot of
critical issues on it! For example, once a user tries to connect to an
unexisting database, the load balancer fails and needs to be
restarted... Another: if closed by Ctrl+C, the postmaster starts in an
infinite loop! We sent these problems to its User List, and we noted
that there are other unsolved issues and a lot of patches not
officially posted yet...
One thing that made us afraid is that the project isn't updated since
march of 2005!
http://pgcluster.projects.postgresql.org/
Too much risky to our critical mission database, we thought!
--> ClusGres
This application should be very promisor, if it weren't "vaporware"...
http://www.linuxlabs.com/clusgres.html
--> C-JDBC / Sequoia
It looks like we're gonna stay with this solution, as I explained on a
later e-mail.
http://c-jdbc.objectweb.org/http://sequoia.continuent.org/
------
Christopher wrote:
I am currently looking into high availability solutions for Postgresql.
I am designing system that should not have a single point of failure.
I would like to at
run-time Add new hardware and add them to my (cluster ) environment
without shutting anything down.
Please advise, Thanks
#1. Is PGCluster production environment ready?
#2. CJDBC.... has anyone used this in production environment with Postgresql?
#3. Any other solutions viable for production environments?
------
Regards,
Rodrigo Hjort
Linux User #348191 (http://counter.li.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: rodrigo.hjort@gmail.com
Subject: Re: Postgresql Replication High Availability
In-Reply-To: <731083980512021932v7b3236cdg@mail.gmail.com>
References: <731083980512021932v7b3236cdg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox