[Pgpool-general] Suggested improvement to failure detection

[Tatsuo Ishii]

> Was looking at this:
> 
>     If you use pg_terminate_backend() to stop a backend, this will
> trigger a failover. The reason why this happens is that PostgreSQL sends
> exactly the same message for a terminated backend as for a full
> postmaster shutdown. There is no workaround as of today. Please do not
> use this function.
> 
> ... and it occurred to me that there's a fix for this.  Instead of
> automatically assuming failover, we could try to reconnect to that
> server and only initiate failover if we can't reconnect.  Any reason
> that wouldn't work?

Oh, interesting idea. Let me check if it's doable.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp