<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body>
    <p>Please help to understand why frontend clients  lose connection
      to pgpool after some idle and how can it be overcome. <br>
    </p>
    <pre class="moz-signature" cols="72">Regards, 
 Nikolay</pre>
    <div class="moz-cite-prefix">09.04.2021 12:36, Nikolay Mastilo (HM)
      пишет:<br>
    </div>
    <blockquote type="cite" cite="mid:DBAP191MB12760492F76973E598D435BFC8739@DBAP191MB1276.EURP191.PROD.OUTLOOK.COM">
      
      <p>our clients are microservices running on k8s. and if they are
        connected directly to database, the connection resume
        successfully. <br>
      </p>
      <p>and if they are connected to pgpool, they cannot resume
        connection after some time.</p>
      <p>some clients outside of kubernetes (for ex. pgAdmin) <b>cannot
        </b>resume connection after some time too. but the DBeaver
        resumes connection successfully.</p>
      <p>magic<br>
      </p>
      <div class="moz-cite-prefix">09.04.2021 12:01, Anton Melser пишет:<br>
      </div>
      <blockquote type="cite" cite="mid:CAFPFXDti0oY6hgcdQufYLid_LtO-8wK1r1+mF+-JyyxeGmgLPw@mail.gmail.com">
        <div dir="ltr">
          <div dir="ltr"><br>
          </div>
          <div class="gmail_quote">
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div>
                <p>And we have such issue - after approx 2 hours of idle
                  our client service cannot resume connection with
                  pgpool, we have to restart client service only that
                  doesn't acceptable for us.</p>
                <p>Could you tell why doesn't  pgpool accept requests
                  after 2 hours of idle and what we should do?</p>
              </div>
            </blockquote>
            <div>And you definitely don't have this with normal pgpool
              outside of Kubernetes and these clients? I am pretty sure
              I have python clients (inside the cluster) that sometimes
              aren't doing anything for multiple hours and they stay
              connected fine. Your clients are also inside your cluster,
              right?  </div>
            <blockquote class="gmail_quote" style="margin:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div>
                <blockquote type="cite">
                  <div dir="ltr">
                    <div dir="ltr">
                      <div class="gmail_quote"> </div>
                    </div>
                  </div>
                </blockquote>
              </div>
            </blockquote>
          </div>
        </div>
      </blockquote>
    </blockquote>
  </body>
</html>