<html><head></head><body><div class="ydpf58ccf74yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>My understanding is that pgpool watchdog will shut off a node when the trusted server cannot be reached, i.e. I don't believe the test is done only after degenerated state was detected. I am not 100% sure, I'll have to test again.</div><div><br></div><div>So the problem is that this trusted server is now the single point of failure ! But you can put a list of IP addresses in this config, so I would also add the ip addresses of the other watchdog node: this way watchdog will not kill a node as long as it can see the other one.</div><div><br></div><div class="ydpf58ccf74signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp46e0eccbyahoo_quoted_3548229404" class="ydp46e0eccbyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, March 13, 2019, 2:28:30 PM GMT+1, Alexander Dorogensky <amazinglifetime@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp46e0eccbyiv8488742797"><div dir="ltr"><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;">Hi everyone,</div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;"><br></div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;">We generally set this parameter to one host to remedy split brain situations but some customers have unreliable networks and therefore ping to that host would fail and pgpool would shut down. </div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;"><br></div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;">My understanding was that trusted server(s) connection will only be tested after degenerated state was detected (before triggering failover), is it correct?</div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;"><br></div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;">If not.. how do I configure trusted servers in a flaky network?</div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;"><br></div><div class="ydp46e0eccbyiv8488742797gmail_default" style="font-family:courier new, monospace;">Thanks <br></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></body></html>