<div dir="ltr">Hi Team,<div><br></div><div>Am using pgpool version 3.3.3 with load-balancing feature. </div><div><br></div><div>My question is, during month end, users are executing long running queries </div><div>via pgpool and those queries are running on Slave node(which is good). Sometimes we </div><div>get request from same user to stop those queries, in such cases we cannot </div><div>stop those queries using pg_cancel_backend() and we are forced to terminate those </div><div>those session using pg_termiante_backend. But this is also not recommended because </div><div>as per doc's pg_terminate_backend is not honoured by pgpool. </div><div><br></div><div>We also noticed on terminating pgpool session using pg_terminate_backend pgpool </div><div>becomes unresponsive and there will change in status_node as below.</div><div><br></div><span style="font-size:12.8000001907349px">node_id | hostname | port | status | lb_weight | role </span><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px">---------+----------------+------+--------+-----------+---------</span><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px">0 | 192.168.20.103 | 5444 | 3 | 0.500000 | standby</span><br style="font-size:12.8000001907349px"><div><span style="font-size:12.8000001907349px">1 | 192.168.20.104 | 5444 | 2 | 0.500000 | standby</span> </div><div><div><br></div><div>So,my question here, is there a way to terminate the pgpool processes ?</div><div><br></div>-- <div>Regards<div>Raghav</div><div>Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div></div>
</div></div>