<html><head><title>Re: [pgpool-general: 5608] failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"</title>
</head>
<body>
<span style=" font-family:'Courier New'; font-size: 10pt;">Hello, Yong.<br>
<br>
Try using the "fast" option for stopping pgpool:<br>
This is how I did this: <br>
cat /etc/systemd/system/pgpool2.service.d/override.conf<br>
[Service]<br>
ExecStart=<br>
ExecStart=/usr/local/bin/pgpool -n -D<br>
ExecStop=/usr/local/bin/pgpool -m fast stop<br>
StandardOutput=syslog<br>
StandardError=syslog<br>
SyslogIdentifier=pgpool2<br>
<br>
<br>
About starting error, I guess socket file was not correctly deleted during previous shutdown. Try deleting it manually and stopping pgpool with "fast" option next time as described above. <br>
<br>
Hope it helps.<br>
<br>
<br>
You wrote 4 июля 2017 г., 14:35:19:<br>
<br>
<a name="divtagdefaultwrapper"></a>
</span><table>
<tr>
<td width=2 bgcolor= #0000ff><br>
</td>
<td><span style=" font-family:'calibri'; font-size: 12pt;">Does anyone have the same issue with mine?<br>
<br>
OS: Ubuntu16.04<br>
Pgpool2: 3.6.4-1.pgdg16.04+1<br>
PostgreSQL: 9.6.3-1.pgdg16.04+1<br>
<br>
Pgpool2 service is controlled by systemd.<br>
<br>
Issues:<br>
</span>
<ol style="text-indent: 0px; margin-left: 40px; list-style-position: outside; list-style-type: decimal;">
<li class=rvps0><span style=" font-family:'calibri'; font-size: 12pt;">“Systemctl stop pgpool2” will take a long time and finally will be failed</span></li>
<li class=rvps0><span style=" font-family:'calibri'; font-size: 12pt;">“systemctl start pgpool2” will have below errors in logs:</span></li>
</ol>
<span style=" font-family:'calibri'; font-size: 12pt;">Jul 4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: FATAL: failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"<br>
Jul 4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: DETAIL: bind socket failed with error: "Address already in use"<br>
Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED<br>
Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Unit entered failed state.<br>
Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Failed with result 'exit-code'.<br>
</td>
</tr>
</table>
<br><br>
<br>
<br>
<span style=" font-family:'arial'; color: #c0c0c0;"><i>-- <br>
Best regards,<br>
Pavel </i></span><a style=" font-family:'arial';" href="mailto:balroga3@yandex.ru">mailto:balroga3@yandex.ru</a></body></html>