[pgpool-general: 5849] Re: pgpool ver. 3.6.6 / problem with restart

Aleksander Englert aleksander_englert at skg.pl
Thu Jan 11 17:38:44 JST 2018


Thanks for fast reaction. The problem is that as soon as I connect to 
pgpool only with pgadmin, restart is not possible, pgpool is hanging. 
When I close the pgadmin, pgpool is then turned off and waits to start. 
The entire process path is shown in the following step-by-step 
screenshots. Earlier, pgpool version 3.2.3 was used and a similar 
problem did not occur. 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.


#################  1 step #################
Connection to pgpool by pgadmin
########################################



#################  2 step #################

########################################



#################  3 step  #################

########################################



#################  4 step  #################
Pgpool hangs, I close the pgadmin.
########################################



#################  5 step  #################


########################################



#################  6 step  #################


########################################


#################  7 step #################



########################################



#################  8 step #################

########################################



################# 9 step  #################

########################################

W dniu 11.01.2018 o 08:22, Tatsuo Ishii pisze:
>> 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.
> 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: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>

-- 
Pozdrawiam / Best regards
Aleksander Englert
aleksander_englert at skg.pl
tel. 33/8281168
kom. +48692469269

SKG S.A.
43-309 Bielsko-Biała, Al. Armii Krajowej 336
tel. +48 33 8281-100, fax +48 33 8281-105
e-mail: firma at skg.pl

Nr KRS: 47940, Sąd Rejonowy w Bielsku-Białej, VIII Wydział Gospodarczy KRS
NIP: 547-12-57-936, Regon: 070711270
Kapitał zakładowy: 500 000 zł w całości opłacony

Niniejsza wiadomość może zawierać informacje prawnie chronione. 
Wiadomość skierowana jest wyłącznie do
adresata/ adresatów określonych wyżej i stanowi własność nadawcy. 
Odbiorca, który otrzymał tę wiadomość
przypadkowo, proszony jest o jej nie rozpowszechnianie, a następnie 
poinformowanie nadawcy i jej
usunięcie. Rozpowszechnianie, kopiowanie, ujawnianie lub przekazywanie 
osobom trzecim w jakiejkolwiek
formie informacji zawartych w niniejszej wiadomości w całości lub części 
jest zakazane.

The information contained in this message may be privileged and 
confidential and protected from disclosure.
Information included in that message is addressed only to the 
addressee/addressees determined above and is the property
of the sender. If you have received this communication in error, please 
notify the sender immediately by replaying
to the message and deleting it from your computer. Any dissemination, 
distribution or copying of this communication
to the third parties is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cpkobdlimnikanfp.png
Type: image/png
Size: 40037 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kicdjlhjpndbggil.png
Type: image/png
Size: 48089 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jkfljpaflbpecdme.png
Type: image/png
Size: 26410 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: olaigpjdejgdfigg.png
Type: image/png
Size: 52017 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ocpaoddcihmkndog.png
Type: image/png
Size: 5107 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fmpoiaokgkbgdnij.png
Type: image/png
Size: 18506 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: deccdmlapmjhjggk.png
Type: image/png
Size: 53004 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4002 bytes
Desc: Kryptograficzna sygnatura S/MIME
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180111/fb600716/attachment-0001.p7s>


More information about the pgpool-general mailing list