Thread: High Availability for PostgreSQL

High Availability for PostgreSQL

From
"Sharon Schooley"
Date:
Hello,
 
We are looking for a 24/7 PostgreSQL solution. I've read some postings and information on various solutions including Taygeta, pgpool and Mammoth PostgreSQL with Heartbeat.  If there are any users of these or other PostgreSQL high availability solutions out there, can you respond and let me know what is working for you and how long you have been up and running? 
 
Our project is a high profile but simple application that must run 24/7.  We are
a county government entity.  We are not currently PostgreSQL users.  Our o/s is
Suse 9.0 Pro Server.
 
Thank you,

Sharon Schooley
Database Analyst
Kern County Information Technology Services
1215 Truxtun Avenue
Bakersfield, CA 93301
(661) 868-2263

 

Re: High Availability for PostgreSQL

From
Peter Eisentraut
Date:
Sharon Schooley wrote:
> We are looking for a 24/7 PostgreSQL solution. I've read some
> postings and information on various solutions including Taygeta,
> pgpool and Mammoth PostgreSQL with Heartbeat.  If there are any users
> of these or other PostgreSQL high availability solutions out there,
> can you respond and let me know what is working for you and how long
> you have been up and running?

We use shared storage and heartbeat, or DRBD and heartbeat.  We have
several installations have have been running for at least a year.  It's
easy to set up, low maintenance, and it works.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/