How can I avoid PGPool as a single point of failure?

From: "snewman18(at)gmail(dot)com" <snewman18(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How can I avoid PGPool as a single point of failure?
Date: 2007-08-14 02:41:00
Message-ID: 1187059260.837960.289020@b79g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My application currently has a single PG 8.2 database server, and I'm
bringing more boxes online to mitigate the risk of a single point of
failure.

I'm interested in using PGPool to do the load balancing, and it was
suggested that I put one server running PGPool in front of two
database servers. This only seems to move my risk to the PGPool
machine.

Is it possible to point two servers running PGPool at the same two
database servers? If so, I seem to recall reading about being able to
use some kind of virtual IP address to split the traffic to both.

Any ideas are greatly appreciated!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lim Berger 2007-08-14 02:41:03 Postgresql INSERT speed (how to improve performance)?
Previous Message Scott Marlowe 2007-08-14 02:29:23 Re: Index not being used