Re: [ADMIN] Best option for expanding beyond 1 pg server in this situation

2008-11-26 Thread Jaume Sabater
- Jamie Tufnell [EMAIL PROTECTED] escribió: pgpool-II with heartbeat for failover. The pgpool-II configuration matrix (http://pgpool.projects.postgresql.org/) isn't terribly clear (there's no legend) but it leads me to believe failover and load balancing are mutually exclusive options.

[ADMIN] Best option for expanding beyond 1 pg server in this situation

2008-11-25 Thread Jamie Tufnell
Hi, We have been wanting to HA our pgsql server for some time now. We're actually reaching the limits of our current server now, so there is a pressing need to do something to ease the load too. There are several individual solutions to both of these problems. I was hoping I could get some

Re: [ADMIN] Best option for expanding beyond 1 pg server in this situation

2008-11-25 Thread Scott Marlowe
On Tue, Nov 25, 2008 at 8:48 PM, Jamie Tufnell [EMAIL PROTECTED] wrote: Hi, We have been wanting to HA our pgsql server for some time now. We're actually reaching the limits of our current server now, so there is a pressing need to do something to ease the load too. There are several