[pgpool-general: 6455] Re: trusted_servers

[Pierre Timmermans]

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.
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.
Pierre 

    On Wednesday, March 13, 2019, 2:28:30 PM GMT+1, Alexander Dorogensky <amazinglifetime at gmail.com> wrote:  
 
 Hi everyone,
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. 
My understanding was that trusted server(s) connection will only be tested after degenerated state was detected (before triggering failover), is it correct?
If not.. how do I configure trusted servers in a flaky network?
Thanks 
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190314/9d6526ce/attachment.html>