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