<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Menlo;
        panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#0563C1;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#954F72;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"HTML Preformatted Char";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
span.HTMLPreformattedChar
        {mso-style-name:"HTML Preformatted Char";
        mso-style-priority:99;
        mso-style-link:"HTML Preformatted";
        font-family:"Courier New";}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D">What is your postgres configuration for
</span>max_connections and superuser_reserved_connections?&nbsp; <span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D">
Do you run pgpool and postgres on the same machine?&nbsp; <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D">I have the same problem.&nbsp; I posted my connection problem on Monday in mail titled &quot;Postgres / pgpool connection configuration&quot;.&nbsp; Every few days the connection
 with port 9999 wait forever and at the same time connection with port 5432 work right-a-way.&nbsp; It might be related to the fact that we test failover and resets on the setup.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>Etienne Journet<br>
<b>Sent:</b> Thursday, September 22, 2016 10:32 AM<br>
<b>To:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> [pgpool-general: 5015] Problem connecting to pgpool<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">I have, quite frequently, a problem connecting to pgpool. The application seems to not be able to allow other connections but doesn’t reject them, it makes them hang forever.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">It does not affect existing connection, but sometimes when I want to restart my front office I have to restart the pgpool service to make it work and allow connections.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Here are the logs at the moment (with my restart) :<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:49:20: pid 1939: LOG:&nbsp; child process with pid: 10496 exits with status 512<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:49:20: pid 1939: LOG:&nbsp; fork a new child process with pid: 10922<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:49:30: pid 1939: LOG:&nbsp; child process with pid: 10841 exits with status 512<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:49:30: pid 1939: LOG:&nbsp; fork a new child process with pid: 10923<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:51:21: pid 1939: LOG:&nbsp; child process with pid: 10877 exits with status 512<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:51:21: pid 1939: LOG:&nbsp; fork a new child process with pid: 10931<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:52:01: pid 1939: LOG:&nbsp; child process with pid: 10897 exits with status 512<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:52:01: pid 1939: LOG:&nbsp; fork a new child process with pid: 10934<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10977: LOG:&nbsp; stop request sent to pgpool. waiting for termination...<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 1939: LOG:&nbsp; received fast shutdown request<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:52:01: pid 1939: LOG:&nbsp;&nbsp;fork a new child process with pid: 10934</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10977: LOG:&nbsp; stop request sent to pgpool. waiting for termination...<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 1939: LOG:&nbsp; received fast shutdown request<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">.2016-09-21 17:54:58: pid 1939: LOG:&nbsp; shutdown request. closing listen socket<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10819: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10922: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10598: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10934: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10846: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10904: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10605: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10900: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 6935: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10852: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10714: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10868: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10888: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10913: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10687: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10903: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10883: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10918: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10919: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10538: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10742: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10912: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10908: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10923: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10905: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10909: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10685: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10871: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10544: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10931: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10896: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:58: pid 10853: LOG:&nbsp; child process received shutdown request signal 2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">done.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:59: pid 11016: LOG:&nbsp; reading status file: 0 th backend is set to down status<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:59: pid 11016: LOG:&nbsp; Setting up socket for 0.0.0.0:9999<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:59: pid 11016: LOG:&nbsp; Setting up socket for :::9999<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:&quot;Menlo&quot;,serif">2016-09-21 17:54:59: pid 11016: LOG:&nbsp; pgpool-II successfully started. version 3.4.5 (tataraboshi)<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">I’m not using health check because my infrastructure handles it 'by itself&nbsp;». I’m joining you my conf :&nbsp;<o:p></o:p></p>
</div>
</div>
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you
 should not copy or use this e-mail for any purpose nor disclose its contents to any person.
</body>
</html>