[pgpool-general: 6768] Re: Watchdog does not get consensus for failover

[Muhammad Usama]

On Sat, Nov 2, 2019 at 2:19 PM shacky <shacky83 at gmail.com> wrote:

> Thanks Muhammad!
>
>
>> Can you share the pgpool.conf files for all nodes. My suspicion is that
>> the health-check timeout values
>> are somewhat on the higher side, So that's why the  health-check might
>> have missed the unavailability of
>> PG server.
>>
>
> Here you can download the pgpool.conf file running on every PgPool node (I
> removed sensitive data): https://we.tl/t-5Zj7o8BK8x
>

All pgpool.conf files are using 40-second health check period, That means a
pgpool-II node can take up to 40 seconds to detect a backend node
failure. In your test how long did you waited for the pgpool to make a
failover consensus?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20191104/306a1c2a/attachment.html>