[pgpool-hackers: 3323] Re: Speeding up failover when all of backends are down

Tatsuo Ishii ishii at sraoss.co.jp
Fri May 3 09:18:28 JST 2019

> Currently Pgpool-II tries to find primary node till
> search_primary_node_timeout expires even if all of the backend are
> down. This is not only a waste of time but it looks like Pgpool-II
> hangs because while searching primary node failover process is
> suspended and all of the Pgpool-II child process are in defunct state,
> thus there's no process which accepts connection requests from
> clients.
> I think if all of the backnds are down, we could immediately give up
> finding primary node regardless search_primary_node_timeout and
> promptly finish the failover process. Attached is the patch to
> implement that.
> Comments?

Since there was no objection, I pushed the patch to all supported

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

More information about the pgpool-hackers mailing list