[Pgpool-general] graceful detach

[Tatsuo Ishii]

> On Mon, 2006-09-18 at 21:21 +0900, Tatsuo Ishii wrote:
> > > Is there a way to detach a node "gracefully" from pgpool-II?
> > > 
> > > If not, would it be reasonably easy to implement? I might have some time
> > > to attempt a patch.
> > > 
> > > Regards,
> > > 	Jeff Davis
> > 
> > I think we could implement it by changing
> > main.c:failover_handler(). you also need to enhance pcp command to
> > accept "gracefull". Finally you need to modify pgpoolAdmin adding
> > "gracefull detatch" button.
> 
> Ok, I infer that CON_CONNECT_WAIT means that the pgpool process is
> currently connected to that PG backend, but no client is currently using
> it.

No. once CON_UP is set, even if client discconnects to pgpool, it does
not be back to CON_CONNECT_WAIT until pgpool restarts for degeneration
or failover etc.

> So, when a client stops using a backend, what changes it's status from
> CON_UP to CON_CONNECT_WAIT?

As I said above, it will not be changed to CON_CONNECT_WAIT until
pgpool restarts.

> Also, have you seen this message? I attached a patch to fix the
> weighting calculation, but I haven't heard anything. 
> http://lists.pgfoundry.org/pipermail/pgpool-hackers/2006-
> September/000034.html

Sorry, I have no time to verify the caliculation right now. Please
wait a new days.
--
Tatsuo Ishii
SRA OSS, Inc. Japan