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

Tatsuo Ishii ishii at sraoss.co.jp
Wed Feb 8 09:26:46 JST 2017


Please take a look at the FAQ.

http://pgpool.net/mediawiki/index.php/FAQ#Can_I_use_pg_cancel_backend.28.29_or_pg_terminate_backend.28.29.3F

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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.
> 
> 
> 
> Thanks
> 
> Avi
> 
> 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.


More information about the pgpool-general mailing list