[pgpool-general: 3970] Re: How does one terminate/cancel queries via PGPool safely?

[Tatsuo Ishii]

> 1) This one is really really dumb but ... here it goes ... could
>    PGPool look at the error code and if it thinks PostgreSQL is
>    shutting down, look at the corresponding command sent and if the
>    string 'pg_terminate_backend()' is found in the string, not
>    degenerate?

I don't think this is doable. The backend sends the error code is
different from the one receives pg_terminate_backend(). So by looking
at the backend which sent the error code does not help if the error
code was originates pg_terminate_backend() or not.

>    Perhaps make it controllable via a pgpool.conf parameter?
> 
> 2) If the above isn't doable, how can we make PGPool disable sending
>    'pg_terminate_backend()'?

Currently it is not possible. The only workaround I can think of is
removing execute privilege from the function and allow to execute
only by super user.

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