<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><font face="Arial">Thanks for your interest in the matter. The
active passive solution is not possible. As for the pgpool
reboot, in version 3.2.3 we used the fast option and all
connections were closed. Pgpool restarted nicely. So something
changed in newer versions?</font><br>
</p>
<br>
<div class="moz-cite-prefix">W dniu 11.01.2018 o 09:53, Piotr
Gbyliczek pisze:<br>
</div>
<blockquote type="cite" cite="mid:5537815.N0Xhr3Z6dx@shadow"> <br>
<br>
<table cellspacing="0" cellpadding="0" width="800" border="0">
<tbody>
<tr>
<td colspan="8" valign="top">
<table cellspacing="0" cellpadding="0" width="800"
border="0">
<tbody>
<tr>
<td colspan="8" valign="top">
<table cellspacing="0" cellpadding="0" width="800"
border="0">
<tbody>
<tr>
<td rowspan="2" valign="top" width="40">
<table cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr>
<td><img
src="cid:part1.41B0F3E7.0582D218@skg.pl"
class="" border="0"></td>
</tr>
</tbody>
</table>
</td>
<td rowspan="2" width="9"> </td>
<td cellpadding="0" cellspacing="0"
valign="top" width="480">
<span style="font-size: 20px; font-weight:
bold; font-family: Arial; margin: 0;
padding: 0;">Piotr Gbyliczek</span>
<hr style="height: 0; border-top-style:
solid; border-top-color: #E05206; color:
#E05206; margin: 4px 0px; border-width:
1px 0 0;"> <span style="font-weight:
lighter; font-size: 14px; font-family:
Arial; margin: 0; padding: 0;">Solutions
Engineer</span>
<table cellspacing="0" cellpadding="0"
width="100%" border="0">
<tbody>
<tr>
<td style="font-size: 4px;"
cellpadding="0" cellspacing="0"
height="4"> </td>
</tr>
<tr>
<td valign="top" width="56%"> <span
style="font-size: 11px;
font-family: Arial; margin: 0;
padding: 0;">
ddi. <strong>08454 210444</strong><br>
t. <strong>0845 123 2222</strong>
<br>
e. <strong
style="color:#303a3d;
text-decoration:none;"><a class="moz-txt-link-abbreviated" href="mailto:P.Gbyliczek@node4.co.uk">P.Gbyliczek@node4.co.uk</a></strong></span>
</td>
<td valign="top" align="left"
width="44%"><span
style="font-size: 11px;
font-family: Arial; margin: 0;
padding: 0;"><strong>Nottingham
Office</strong><br>
Node4 Ltd, The POD,<br>
10 Bottle Ln, Nottingham, NG1
2HL</span></td>
</tr>
</tbody>
</table>
<p> </p>
</td>
<td colspan="8" valign="top" align="right">
<table cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr>
<td><a href="http://www.node4.co.uk"
moz-do-not-send="true"><img
alt="Visit www.node4.co.uk"
src="cid:part2.AE312328.8E0CD594@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
<table cellspacing="0" cellpadding="0"
height="46" width="100%" border="0">
<tbody>
<tr>
<td colspan="8" style="font-size:
4px;" cellpadding="0"
cellspacing="0" height="12"><br>
</td>
</tr>
<tr>
<td> </td>
<td align="right">
<table cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="http://www.node4.co.uk"
moz-do-not-send="true"><img
alt="Visit
www.node4.co.uk"
src="cid:part4.4BB83096.32AC3D91@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
<td> </td>
<td align="right">
<table cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="http://www.twitter.co.uk/Node4Ltd"
moz-do-not-send="true"><img
alt="Visit Node4 on
Twitter"
src="cid:part6.CD3E0DAC.6B63D6DF@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
<td> </td>
<td align="right">
<table cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="https://www.linkedin.com/company/node4-ltd"
moz-do-not-send="true"><img
alt="Visit Node4 on
Linkedin"
src="cid:part8.68CB3D21.AA077ED3@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
<td> </td>
<td align="right">
<table cellspacing="0"
cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="http://www.facebook.com/Node4"
moz-do-not-send="true"><img
alt="Visit Node4 on
Facebook"
src="cid:part10.9F98ADD3.DADC487A@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p> </p>
</td>
<td rowspan="2" width="10"> </td>
<td rowspan="2" valign="top" width="40">
<table cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr>
<td><img
src="cid:part1.41B0F3E7.0582D218@skg.pl"
class="" border="0"></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table cellspacing="0" cellpadding="0" width="800"
border="0">
<tbody>
<tr>
<td>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="https://www.node4.co.uk/events/how-to-solve-your-database-management-challenge/"
moz-do-not-send="true"><img
src="cid:part13.BD913A1E.2783D38B@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
<td>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td><a
href="https://www.node4.co.uk/events/leeds-open-day/"
moz-do-not-send="true"><img
src="cid:part15.47560F0A.F0A6210E@skg.pl"
class="" border="0"></a></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p> </p>
</td>
</tr>
<tr>
<td colspan="8"> On Thursday, 11 January 2018 08:38:44 GMT
Aleksander Englert wrote:<br>
> Thanks for fast reaction. The problem is that as soon
as I connect to<br>
> pgpool only with pgadmin, restart is not possible,
pgpool is hanging.<br>
> When I close the pgadmin, pgpool is then turned off
and waits to start.<br>
> The entire process path is shown in the following
step-by-step<br>
> screenshots. Earlier, pgpool version 3.2.3 was used
and a similar<br>
> problem did not occur. I will just say that the topic
is very important<br>
> to us, because it is about using pgpool in the
application used in the<br>
> Ministry of Finance.<br>
<br>
AFAIK pgpool does wait for connections to be closed on
stopping. <br>
<br>
The timeout that Tatsuo suggested should help with that,
but setting it too <br>
low may cause some legitimatelly idle connections being
cut off.<br>
<br>
You can have a look at this (from pgpool --help) : <br>
<br>
=================<br>
Stop options:<br>
-m, --mode=SHUTDOWN-MODE<br>
Can be "smart", "fast", or "immediate"<br>
<br>
Shutdown modes are:<br>
smart quit after all clients have disconnected<br>
fast quit directly, with proper shutdown <br>
immediate the same mode as fast <br>
=================<br>
<br>
and set appropriate option in /etc/sysconfig/pgpool or in
pgpool.conf (not <br>
sure if that is possible there)<br>
<br>
Another solution may be to add another pgpool server and
use watchdog. I've <br>
seen pgpool hanging on stop all the time, but since we use
it normally in <br>
active passive pair, watchdog detects that pgpool is
stopped and passive <br>
pgpool pick ups the active role, thus allowing new
connections to go through <br>
to database. I usually wait few minutes on the former
active server and then <br>
kill pgppool processes there, then start pgpool back as
passive server in <br>
pair. <br>
<br>
<br>
Regards,<br>
Piotr<br>
-- <br>
<small style="font-family: Arial; color: #8E908F;">
<br>
Node4 Limited is registered in England No: 04759927 and
has its registered office at Millennium Way, Pride Park,
Derby, DE24 8HZ<br>
The information contained in this email is confidential
and is intended for the exclusive use of the email
addressee shown.<br>
If you are not the addressee, any disclosure,
reproduction, distribution or other dissemination or use
of this communication is strictly prohibited.<br>
If you have received this mail in error, please notify
our mail manager at <a href="mailto:abuse@node4.co.uk"
style="color: #E05206; text-decoration: none;"
target="_blank" moz-do-not-send="true">abuse@node4.co.uk</a>
and delete it from your system.<br>
Opinions expressed in this email are those of the
individual not the company, unless specifically
indicated to that effect.
<hr style="height: 0; border-top-style: solid;
border-top-color: #D1D4D3; margin: 4px 0px;
border-width: 1px 0 0;">
This email has been scanned by Node4's Email Security
System.
<hr style="height: 0; border-top-style: solid;
border-top-color: #D1D4D3; margin: 4px 0px;
border-width: 1px 0 0;">
This email message has been delivered safely and
archived online by Mimecast.</small> </td>
</tr>
</tbody>
</table>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</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>