Re: [GENERAL] Improving Availability

2005-12-15 Thread Guido Neitzer
On 15.12.2005, at 9:10 Uhr, Brendan Duddridge wrote: What about Sequoia? Is that better or worse than pgpool? That looks interesting, I haven't seen it yet. Has anyone experiences to share? cug smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] Improving Availability

2005-12-15 Thread Brendan Duddridge
Hi Guido / Richard / Scott, What about Sequoia? Is that better or worse than pgpool? Thanks Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, A

Re: [GENERAL] Improving Availability

2005-12-14 Thread Guido Neitzer
Hi Scott, hi Richard, On 14.12.2005, at 17:30 Uhr, Scott Marlowe wrote: This setup I'm talking about would have pgpool on each db server. If you meant pgpool running on both application servers, that would work fine with slony in the background and pgpool in load balancing mode, or with p

Re: [GENERAL] Improving Availability

2005-12-14 Thread Scott Marlowe
On Wed, 2005-12-14 at 10:29, Scott Marlowe wrote: > On Wed, 2005-12-14 at 10:19, Guido Neitzer wrote: > > On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: > > > > > I'd be tempted to look at pgpool sitting between your application > > > and the database, and then replication from the one machi

Re: [GENERAL] Improving Availability

2005-12-14 Thread Scott Marlowe
On Wed, 2005-12-14 at 10:19, Guido Neitzer wrote: > On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: > > > I'd be tempted to look at pgpool sitting between your application > > and the database, and then replication from the one machine to the > > other. > > Right, I thought the same, BUT:

Re: [GENERAL] Improving Availability

2005-12-14 Thread Richard Huxton
Guido Neitzer wrote: On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: I'd be tempted to look at pgpool sitting between your application and the database, and then replication from the one machine to the other. Right, I thought the same, BUT: I have two application servers (one on each mach

Re: [GENERAL] Improving Availability

2005-12-14 Thread Guido Neitzer
On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: I'd be tempted to look at pgpool sitting between your application and the database, and then replication from the one machine to the other. Right, I thought the same, BUT: I have two application servers (one on each machine) connecting to

Re: [GENERAL] Improving Availability

2005-12-14 Thread Richard Huxton
Guido Neitzer wrote: Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually nee

Re: [GENERAL] Improving Availability

2005-12-14 Thread Joshua D. Drake
Guido Neitzer wrote: Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually

[GENERAL] Improving Availability

2005-12-14 Thread Guido Neitzer
Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually need is a mechanism th