Re: [HACKERS] pgpool question

2005-03-09 Thread Oleg Bartunov
On Thu, 10 Mar 2005, Tatsuo Ishii wrote: However it would be easy to modify pgpool to allow automatic switch back (with a risk of unwanted repeating switching, of course). Is this what you want? No, your arguments are important. I don't want too much intelligence, but when I restart primary backend

Re: [HACKERS] pgpool question

2005-03-09 Thread Tatsuo Ishii
> On Thu, 10 Mar 2005, Tatsuo Ishii wrote: > > >> I'm experimenting with pgpool 2.51 on my Linux box runnung > >> two postgresql backends: pg74:5432 and pg801:5433 > >> > >> I configured pgpool to use pg74:5432 as primary backend and > >> pg801:5433 as second one. Pgpool is running on default port

Re: [HACKERS] pgpool question

2005-03-09 Thread Oleg Bartunov
On Thu, 10 Mar 2005, Tatsuo Ishii wrote: I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. Pgpool is running on default port () and I configured my we

Re: [HACKERS] pgpool question

2005-03-09 Thread Jeff Hoffmann
On Mar 9, 2005, at 7:25 PM, Tatsuo Ishii wrote: That's an intended behavior. Or at least a side effect of failover design. If we allow unlimited switching between the master and the secondary, pgpool could repeat switching forever if we have unliable network or hardware. I didn't really think of it

Re: [HACKERS] pgpool question

2005-03-09 Thread Tatsuo Ishii
> I'm experimenting with pgpool 2.51 on my Linux box runnung > two postgresql backends: pg74:5432 and pg801:5433 > > I configured pgpool to use pg74:5432 as primary backend and > pg801:5433 as second one. Pgpool is running on default port () and > I configured my web application to use it, so

Re: [HACKERS] pgpool question

2005-03-09 Thread Jeff Hoffmann
Oleg Bartunov wrote: On Wed, 9 Mar 2005, Jeff Hoffmann wrote: Oleg Bartunov wrote: I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. Pgpool is running on

Re: [HACKERS] pgpool question

2005-03-09 Thread Oleg Bartunov
On Wed, 9 Mar 2005, Jeff Hoffmann wrote: Oleg Bartunov wrote: I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. Pgpool is running on default port ()

Re: [HACKERS] pgpool question

2005-03-09 Thread Jeff Hoffmann
Oleg Bartunov wrote: I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. Pgpool is running on default port () and I configured my web application to us

[HACKERS] pgpool question

2005-03-09 Thread Oleg Bartunov
I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. Pgpool is running on default port () and I configured my web application to use it, so I could star