[Pgpool-general] trouble with switchover

[Tatsuo Ishii]

> Tatsuo Ishii wrote:
> >>I just downloaded pgpool and I'm trying to learn how to use it.  The 
> >>feature that attracted me to this project is switchover and 
> >>unfortunately that's the thing I'm having problems with.  I've set up a 
> >>master and secondary server in the conf file & was able to connect to 
> >>the master.  I then issued a switch command to switch to the secondary 
> >>server.
> >>
> >>When I try to connect to pgpool, I'm still connecting to the secondary 
> >>server.  Is there something else I have to do to switch back to the 
> >>master server?
> > 
> > 
> > You need to restart pgpool to switch back to normal operation.
> 
> Thanks for confirming this for me.  I was under the impression that you 
> could just signal the daemon somehow to easily switch back and forth 
> between the two.  Do I actually need to issue two commands (i.e., pgpool 
> -m fast stop; pgpool start)

Yes.

> or is there a way to do it in one
> command? 

Currently no.

> I didn't see anything like "pgpool restart" in the documentation.  Also 
> I tried sending the process a SIGHUP just because some other daemons 
> will interpret that as a reset/reload configuration, but that obviously 
> didn't work.  That seems like it would be a handy feature.

Yup. The hardest part would be how to treat child processes which are
running with old configuration. The simplest way would be just
restarting all children but it does not buy anything comparing with
restarting pgpool. Any idea?
--
Tatsuo Ishii