<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><span id="result_box" class="" tabindex="-1" lang="en"><span
class="">Thanks for fast reaction.</span> <span class="">The
problem is that as soon as I connect to pgpool only with
pgadmin, restart is not possible, pgpool is hanging.</span> <span
class="">When I close the pgadmin, pgpool is then turned off
and waits to start.</span> <span class="">The entire process
path is shown in the following step-by-step screenshots.</span>
<span class="">Earlier, pgpool version 3.2.3 was used and a
similar problem did not occur.</span> <span class="">I will
just say that the topic is very important to us, because it is
about using pgpool in the application used in the Ministry of
Finance.</span></span></p>
<br>
################# 1 step #################<br>
<span id="result_box" class="short_text" lang="en"><span class="">Connection
to pgpool by pgadmin<br>
########################################<br>
</span></span><br>
<br>
<br>
################# 2 step #################<br>
<img src="cid:part1.2E85B187.63C6F306@skg.pl" alt="" height="400"
width="651"><br>
<span id="result_box" class="short_text" lang="en"><span class="">########################################<br>
<br>
<br>
</span></span><br>
################# 3 step #################<br>
<img src="cid:part2.E33D852A.32D82F1D@skg.pl" alt="" height="574"
width="653"><br>
<span id="result_box" class="short_text" lang="en"><span class="">########################################<br>
<br>
</span></span><br>
<br>
################# 4 step #################<br>
<span id="result_box" class="short_text" lang="en"><span class="">Pgpool
hangs, I close the pgadmin.<br>
</span></span><span id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text" lang="en"><span
class="">########################################</span></span><br>
</span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><br>
<br>
################# 5 step #################<br>
<img src="cid:part3.E0EB0DE8.304E215F@skg.pl" alt=""
height="427" width="441"><br>
</span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class="">########################################<br>
<br>
<br>
</span></span><br>
</span></span><span id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text" lang="en"><span
class="">################# 6 step #################<br>
<img src="cid:part4.BFB1A444.0A4AFAF9@skg.pl" alt=""
height="663" width="518"><br>
</span></span></span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class="">########################################</span></span><br>
<br>
</span></span></span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text"
lang="en"><span class="">################# 7 step
#################<br>
<img src="cid:part5.7676CE2A.04889318@skg.pl" alt=""><br>
<br>
</span></span></span></span></span></span></span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text"
lang="en"><span class=""><span id="result_box"
class="short_text" lang="en"><span class="">########################################<br>
<br>
<br>
</span></span></span></span></span></span></span></span></span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text"
lang="en"><span class=""><span id="result_box"
class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class="">################# 8 step
#################</span></span></span></span></span></span></span></span></span></span></span></span><br>
<img src="cid:part6.6FA2C79F.25770B05@skg.pl" alt=""><br>
</span></span></span></span><span id="result_box"
class="short_text" lang="en"><span class=""><span id="result_box"
class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class="">########################################<br>
<br>
<br>
</span></span></span></span></span></span><br>
<span id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box" class="short_text"
lang="en"><span class=""><span id="result_box"
class="short_text" lang="en"><span class=""><span
id="result_box" class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class=""><span id="result_box"
class="short_text" lang="en"><span
class="">#################
9 step #################</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span><br>
<img src="cid:part7.86B22DFF.D5C8888A@skg.pl" alt=""
height="522" width="844"><br>
</span></span></span></span><span id="result_box"
class="short_text" lang="en"><span class="">########################################<br>
</span></span><br>
<div class="moz-cite-prefix">W dniu 11.01.2018 o 08:22, Tatsuo Ishii
pisze:<br>
</div>
<blockquote type="cite"
cite="mid:20180111.162213.1695750831306795334.t-ishii@sraoss.co.jp">
<blockquote type="cite">
<pre wrap="">We use the postgres cluster in version 9.4 and pgpool in version
3.6.6. The problem is that when any client is connected to pgpool,
then pgpool's restart is not possible. Pgpool hangs up and waits for
the client to finish the connection. If this happens, pgpool turns off
and must be manually started. The pgpool.conf file with the
configuration in the attachment. I am asking for help in solving the
problem. Thank you in advance.
</pre>
</blockquote>
<pre wrap="">
If you mean by "Pgpool hangs up" is that there are too many
connections (in this case more than 32) from clients to Pgpool and you
cannot make a new connection to Pgpool , "client_idle_limit" may help
you.
If a lazy client has been being idle more than the time specified by
the parameter, the client will be kicked out and a new client can
connect to Pgpool.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
Japanese:<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Pozdrawiam / Best regards<br>
Aleksander Englert<br>
<a class="moz-txt-link-abbreviated" href="mailto:aleksander_englert@skg.pl">aleksander_englert@skg.pl</a><br>
tel. 33/8281168<br>
kom. +48692469269<br>
<br>
SKG S.A. <br>
43-309 Bielsko-Biała, Al. Armii Krajowej 336<br>
tel. +48 33 8281-100, fax +48 33 8281-105<br>
e-mail: <a class="moz-txt-link-abbreviated" href="mailto:firma@skg.pl">firma@skg.pl</a><br>
<br>
Nr KRS: 47940, Sąd Rejonowy w Bielsku-Białej, VIII Wydział
Gospodarczy KRS<br>
NIP: 547-12-57-936, Regon: 070711270<br>
Kapitał zakładowy: 500 000 zł w całości opłacony<br>
<br>
Niniejsza wiadomość może zawierać informacje prawnie chronione.
Wiadomość skierowana jest wyłącznie do<br>
adresata/ adresatów określonych wyżej i stanowi własność nadawcy.
Odbiorca, który otrzymał tę wiadomość<br>
przypadkowo, proszony jest o jej nie rozpowszechnianie, a
następnie poinformowanie nadawcy i jej<br>
usunięcie. Rozpowszechnianie, kopiowanie, ujawnianie lub
przekazywanie osobom trzecim w jakiejkolwiek<br>
formie informacji zawartych w niniejszej wiadomości w całości lub
części jest zakazane.<br>
<br>
The information contained in this message may be privileged and
confidential and protected from disclosure.<br>
Information included in that message is addressed only to the
addressee/addressees determined above and is the property<br>
of the sender. If you have received this communication in error,
please notify the sender immediately by replaying<br>
to the message and deleting it from your computer. Any
dissemination, distribution or copying of this communication<br>
to the third parties is strictly prohibited. </div>
</body>
</html>