<html><body style="font-family: 'Arial', sans-serif; font-size: 14px; color: #303a3d; margin: 0; padding: 0;">
<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"><tr><td><IMG border="0" src="cid:116092209263101939@uk-mta-97.uk.mimecast.lan" ></td></tr></table></td>
<td width="9" rowspan="2"> </td>
<td width="480" valign="top" cellpadding="0" cellspacing="0">
<span style="font-size: 20px; font-weight: bold; font-family: Arial; margin: 0; padding: 0;">Piotr Gbyliczek</span>
<hr style="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;" cellpadding="0" cellspacing="0"> </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 421 0444</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>Newark Office</strong><br />Node4 Ltd, Innovation House,<br />Cafferata Way, Newark, NG24 2TN</span></td>
</tr>
</tbody>
</table>
<p> </p>
</td>
<td colspan="8" align="right" valign="top">
<table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="http://www.node4.co.uk"><IMG border="0" alt="Visit www.node4.co.uk" src="cid:116092209263102139@uk-mta-97.uk.mimecast.lan" ></A></td></tr></table>
<table width="100%" height="46" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td colspan="8" height="12" style="font-size: 4px;" cellpadding="0" cellspacing="0"></td>
</tr>
<tr>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="http://www.node4.co.uk"><IMG border="0" alt="Visit www.node4.co.uk" src="cid:116092209263102239@uk-mta-97.uk.mimecast.lan" ></A></td></tr></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="http://www.twitter.co.uk/Node4Ltd"><IMG border="0" alt="Visit Node4 on Twitter" src="cid:116092209263102439@uk-mta-97.uk.mimecast.lan" ></A></td></tr></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="https://www.linkedin.com/company/node4-ltd"><IMG border="0" alt="Visit Node4 on Linkedin" src="cid:116092209263102039@uk-mta-97.uk.mimecast.lan" ></A></td></tr></table></td>
<td> </td>
<td align="right"><table border="0" cellspacing="0" cellpadding="0"><tr><td><a href="http://www.facebook.com/Node4"><IMG border="0" alt="Visit Node4 on Facebook" src="cid:116092209263102339@uk-mta-97.uk.mimecast.lan" ></A></td></tr></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"><tr><td><IMG border="0" src="cid:116092209263101939@uk-mta-97.uk.mimecast.lan" ></td></tr></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"><tr><td><a href="http://south.convergencesummit.co.uk"><IMG border="0" alt="Convergence Summit South 2016 - Visit us at Stand 75" src="cid:116092209263102539@uk-mta-97.uk.mimecast.lan" ></A></td></tr></table>
</td>
</tr>
</tbody></table>
<p> </p>
</td>
</tr>
<tr>
<td colspan="8">
On Wednesday 21 September 2016 23:12:27 Krzysztof MoĊcicki wrote:<BR>
> Hello<BR>
> <BR>
> I have problem with initiate new connection to master node through<BR>
> pgpool, when slave node goes down.<BR>
> <BR>
> I have configuration, where is streamin replication mode, and<BR>
> failover_over_backend_error is off. System Ubuntu 14.04, Pgpool 3.5.3<BR>
> version + patch from:<BR>
> <a href="http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004884.html" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/2016-July/004884.html</a>,<BR>
> Postgres version 9.4.<BR>
> <BR>
> I tested this on Google Cloud, when are 3 servers:<BR>
> <BR>
> 1. Postgres master + Pgpool (ip: 10.1.0.19),<BR>
> <BR>
> 2. Postgres slave + Pgpool (ip: 10.1.0.23),<BR>
> <BR>
> 3. Pgpool<BR>
> <BR>
> On second server I run "ifdown eth0", and current connections works, but<BR>
> I can't initiate new connection.<BR>
<BR>
So, if I understand correctly, you are shutting down the network interface on <BR>
server 2 and from that point that server has problem connecting to postgresql <BR>
via pgpool ? Would that be because that server is running active pgpool and <BR>
you connecting locally to it, which means on simulated downtime it has lost <BR>
connection to primary database in pool (which sits on server 1, right )? <BR>
<BR>
Regards<BR>
Piotr<BR>
<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;" 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="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="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>
</body></html>