[pgpool-general: 5305] execute pg_terminate_backend() without failover

Avi Weinberg AviW at gilat.com
Wed Feb 8 00:41:44 JST 2017

Hi all,

On some setups when we execute pg_terminate_backend() on connection that is using the VIP and port 9999 it causes a failover.

How can we terminate a query without having a failover?

Is it safe to kill pgpool process for that query.  Will it close pgpool connection and postgres connection properly?

If it is not closing it properly what can we do to prevent reaching the connection limit?

Does it make a difference if we use connection_cache or not?

What is the reason that on some setups this causes a restart and on some not.



IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170207/fb690896/attachment.html>

More information about the pgpool-general mailing list