Re: [GENERAL] How can I avoid PGPool as a single point of failure?

2008-01-29 Thread Chander Ganesan
Hello... [EMAIL PROTECTED] wrote: 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. You could use linux hearbeat to allow one Pgpool serve

Re: [GENERAL] How can I avoid PGPool as a single point of failure?

2008-01-31 Thread Aaron Glenn
On Jan 29, 2008 6:30 PM, Chander Ganesan <[EMAIL PROTECTED]> wrote: > > > 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. > CARP...I've

Re: [GENERAL] How can I avoid PGPool as a single point of failure?

2008-01-31 Thread Vivek Khera
On Jan 31, 2008, at 4:28 AM, Aaron Glenn wrote: CARP *and* pfsync. this late at night off the top of my head I can't see any blatantly obvious reason this wouldn't work (with at least pgpool that is, dunno about your data) we use CARP to balance and failover some webserver pairs. We also use