<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>Hi Piotr</div><div><br></div><div>I believe you can put a list in the trusted_servers configuration; pgpool will commit suicide only when *all* the servers in the list are not reachable. So in the list I would put the other database server, together with an external IP. So that the external IP does not become a single point of failure and so that pgpool will not commit suicide if it can see the other database server</div><div><br></div><div>I am not 100% sure but I believe I tested this scenario</div><div><br></div><div>Regards,</div><div><br></div><div class="ydp499ca559signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydpd18aa145yahoo_quoted_3113913439" class="ydpd18aa145yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, July 23, 2018, 4:55:55 PM GMT+2, Piotr Gbyliczek <P.Gbyliczek@node4.co.uk> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydpd18aa145yiv7473079721"><div>Hi, <br>
<br>
Sorry for reviving old thread, but I've recently gone up to 3.6.7 and observed <br>
same behavior. <br>
<br>
As I understand it, trusted_servers is a mechanism that should prevent standby <br>
pgpool service to bring up the delegated IP, and cause split brain where there <br>
is a network partition between pgpool servers. <br>
<br>
But struggling to see why standby that is able to communicate with it's master <br>
over watchdog channel would declare itself dead upon failing to contact <br>
trusted_servers. <br>
<br>
In fact I've had two scenarios : <br>
- standby pgpool declared itself dead on failing to contact trusted server, <br>
which was discovered when master pgpool was manually stopped and there was no <br>
standby to fall back to.<br>
- master declared itself dead on failing to contact trusted server, which <br>
initiated failover procedure and standby picked up the master role, bringing <br>
up the delegated IP. this is correct behavior in general, but have been <br>
noticed by customers and monitoring, hence some question have been raised. <br>
<br>
I would say both could be avoided, and were unnecessary downtime for the <br>
delegated IP. <br>
<br>
Was there any conclusion to this issue, or design explanation to the behavior <br>
? <br>
<br>
Thanks, <br>
Piotr<br>
-- <br>
<br>
<br>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="8" valign="top"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="8" valign="top"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="40" rowspan="2" valign="top"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><img border="0" src="cid:oyYhwjPU11Gon8xkLCWh" data-inlineimagemanipulating="true" draggable="false"></td></tr></tbody></table></td>
<td width="9" rowspan="2"> </td>
<td width="480" valign="top">
<span style="font-size:20px;font-weight:bold;font-family:Arial;margin:0;padding:0;">Piotr Gbyliczek</span>
<hr style="min-height:0;border-top-style:solid;border-top-color:#E05206;color:#E05206;margin:4px 0px;border-width:1px 0 0;">
<span style="font-weight:lighter;font-size:14px;font-family:Arial;margin:0;padding:0;">Solutions Engineer</span>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr><td height="4" style="font-size:4px;"> </td></tr>
<tr>
<td width="56%" valign="top">
<span style="font-size:11px;font-family:Arial;margin:0;padding:0;">
ddi. <strong>08454 210444</strong><br>
t. <strong>0845 123 2222</strong>
<br>e. <strong style="color:#303a3d;text-decoration:none;">P.Gbyliczek@node4.co.uk</strong></span>
</td>
<td width="44%" align="left" valign="top"><span style="font-size:11px;font-family:Arial;margin:0;padding:0;"><strong>Nottingham Office</strong><br>Node4 Ltd, The POD,<br>10 Bottle Ln, Nottingham, NG1 2HL</span></td>
</tr>
</tbody>
</table>
<p> </p>
</td>
<td colspan="8" align="right" valign="top">
<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://www.node4.co.uk" rel="nofollow" target="_blank"><img border="0" alt="Visit www.node4.co.uk" src="cid:XCCVBVJpxsbfuAFvOaER" data-inlineimagemanipulating="true" data-id="1532631349193" draggable="false"></a></td></tr></tbody></table>
<table width="100%" height="46" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="8" height="12" style="font-size:4px;"></td>
</tr>
<tr>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://www.node4.co.uk" rel="nofollow" target="_blank"><img border="0" alt="Visit www.node4.co.uk" src="cid:SRKnhWb4MUeKl4Ltik5i" data-inlineimagemanipulating="true" draggable="false"></a></td></tr></tbody></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://www.twitter.co.uk/Node4Ltd" rel="nofollow" target="_blank"><img border="0" alt="Visit Node4 on Twitter" src="cid:l9kixV4Th5nCN4xZzJmI" data-inlineimagemanipulating="true" draggable="false"></a></td></tr></tbody></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="https://www.linkedin.com/company/node4-ltd" rel="nofollow" target="_blank"><img border="0" alt="Visit Node4 on Linkedin" src="cid:Qaxjx3GfeLFKr8PAnEuw" data-inlineimagemanipulating="true" draggable="false"></a></td></tr></tbody></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://www.facebook.com/Node4" rel="nofollow" target="_blank"><img border="0" alt="Visit Node4 on Facebook" src="cid:pv9P64EejD301mkrCQGV" data-inlineimagemanipulating="true" draggable="false"></a></td></tr></tbody></table></td>
</tr>
</tbody>
</table>
<p> </p>
</td>
<td width="10" rowspan="2"> </td>
<td width="40" rowspan="2" valign="top"><table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><img border="0" src="cid:oyYhwjPU11Gon8xkLCWh" data-inlineimagemanipulating="true" draggable="false"></td></tr></tbody></table></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://info.node4.co.uk/cloud-transformation-consultancy-services-0" rel="nofollow" target="_blank"><img border="0" src="cid:7bhWNZEy2ZHD8QxvfPaz" data-inlineimagemanipulating="true" draggable="false" style="width: 100%; max-width: 400px;"></a></td></tr></tbody></table></td><td>
<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td><a href="http://info.node4.co.uk/mid-market-it-priorities-in-2018" rel="nofollow" target="_blank"><img border="0" src="cid:WfuW3VmYtGms8tXPfMyG" data-inlineimagemanipulating="true" draggable="false" style="width: 100%; max-width: 400px;"></a></td></tr></tbody></table>
</td>
</tr>
</tbody></table>
<p> </p>
</td>
</tr>
<tr>
<td colspan="8">
<small style="font-family:Arial;color:#8E908F;">
<br>Node4 Limited is registered in England No: 04759927 and has its registered office at Millennium Way, Pride Park, Derby, DE24 8HZ<br>
The information contained in this email is confidential and is intended for the exclusive use of the email addressee shown.<br>
If you are not the addressee, any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited.<br>
If you have received this mail in error, please notify our mail manager at <a href="mailto:abuse@node4.co.uk" style="color:#E05206;text-decoration:none;" rel="nofollow" target="_blank">abuse@node4.co.uk</a> and delete it from your system.<br>
Opinions expressed in this email are those of the individual not the company, unless specifically indicated to that effect.
<hr style="min-height:0;border-top-style:solid;border-top-color:#D1D4D3;margin:4px 0px;border-width:1px 0 0;">
This email has been scanned by Node4's Email Security System.
<hr style="min-height:0;border-top-style:solid;border-top-color:#D1D4D3;margin:4px 0px;border-width:1px 0 0;">
This email message has been delivered safely and archived online by Mimecast.</small>
</td>
</tr>
</tbody>
</table>
</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></div></body></html>