High Availability for PostgreSQL

[Sharon Schooley]

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
[phone]

[Peter Eisentraut]

Post by Sharon Schooley
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.