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 (9999) and
I configured my web application to use it, so I could start/stop backends
without disturbing client (web browser).
When I stop primary backend (pg74:5432) pgpool switched to backend
failover from (5432) to (5433) done
but when I start primary and stopped secondary backend pgpool
never switched back to primary backend as expected ! I see bogus message
like:
starting failover from (5433) to (5433)
What I'm doing wrong ?
I don't think anything. I could be wrong, but my understanding is that if
the primary goes down, you have to restart pgpool after primary comes back
up. It doesn't toggle back and forth from primary <-> secondary when
necessary, it only goes primary->secondary. I played with pgpool for a while
and came up with effectively the same confused question.
Seems, limited functionality. But, then I don't understand
switchover options ([-s {m[aster]|s[econdary]] switch).
What's '-s m switch' for ?
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
