<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 14/04/2021, at 2:21 AM, Nikolay Mastilo (HM) <<a href="mailto:nikm71@hotmail.com" class="">nikm71@hotmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" class="">
<div class=""><p class="">Hello. The approach with tuning tcp timeouts is workable but in
some circumstance it is not applicable. Our customer needs
solution with configuration only in software components, such as:
pgpool, postgresql, etc. The networks where such solution will be
deployed can be unpredictably different in different network
components. So, our solution should be configurable itself for
different network environments.</p></div></div></blockquote>I think you will have a hard time with requirements like that, and asking for free support.<br class=""><blockquote type="cite" class=""><div class=""><div class=""><p class="">We found out that in the event of shortterm loss of connection
between pgpool and database, pgpool detaches node from the pool
and doesn't reconnect its own without restarting. Besides it,
clients that were connected to pgpool have disconnected and cannot
reconnect until pgpool is restarted. <br class="">
</p><p class="">The point is that in our solution we use pgpool as connection
pooler and load balancer only, without controling cluster.
Failoving management is carried out by patroni. <br class="">
</p><p class="">Could anyone advise any pgpool parameters set configuration when
pgpool never detach nodes from its pool but try reconnect with
specified period and continue interact with the client.<br class="">
</p>
</div></div></blockquote>I think you’re looking for auto_failback.</div><div><br class=""></div><div>--</div><div>Nathan Ward</div><div><br class=""></div><br class=""></body></html>