<div dir="ltr">Hi,<div><br></div><div>My pgpool was working fine but now I get the bellow error and it wont start(after a sudden shut down):</div><div>
<p class="gmail-p1"><span class="gmail-s1"><b>●</b></span><span class="gmail-s2"> pgpool-II-95.service - PGPool-II Middleware Between PostgreSQL Servers And PostgreSQL Database Clients</span></p>
<p class="gmail-p1"><span class="gmail-s2"> Loaded: loaded (/usr/lib/systemd/system/pgpool-II-95.service; enabled; vendor preset: disabled)</span></p>
<p class="gmail-p1"><span class="gmail-s2"> Active: </span><span class="gmail-s1"><b>failed</b></span><span class="gmail-s2"> (Result: exit-code) since Sun 2017-02-05 13:50:22 UTC; 33min ago</span></p>
<p class="gmail-p1"><span class="gmail-s2"> Process: 2534 ExecStop=/usr/pgpool-9.5/bin/pgpool -f /etc/pgpool-II-95/pgpool.conf -m fast stop </span><span class="gmail-s1"><b>(code=exited, status=3)</b></span></p>
<p class="gmail-p1"><span class="gmail-s2"> Process: 2532 ExecStart=/usr/pgpool-9.5/bin/pgpool -f /etc/pgpool-II-95/pgpool.conf $OPTS </span><span class="gmail-s1"><b>(code=exited, status=3)</b></span></p>
<p class="gmail-p1"><span class="gmail-s2"> Main PID: 2532 (code=exited, status=3)</span></p>
<p class="gmail-p2"><span class="gmail-s2"></span><br></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: Started PGPool-II Middleware Between PostgreSQL Servers And PostgreSQL Database Clients.</span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: Starting PGPool-II Middleware Between PostgreSQL Servers And PostgreSQL Database Clients...</span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool pgpool[2532]: 2017-02-05 13:50:22: pid 2532: FATAL: failed to bind a socket: "/tmp/.s.PGSQL.5432"</span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool pgpool[2532]: 2017-02-05 13:50:22: pid 2532: DETAIL: bind socket failed with error: "Address already in use"</span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: <b>pgpool-II-95.service: main process exited, code=exited, status=3/NOTIMPLEMENTED</b></span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool pgpool[2534]: 2017-02-05 13:50:22: pid 2534: FATAL: could not read pid file</span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: <b>pgpool-II-95.service: control process exited, code=exited status=3</b></span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: <b>Unit pgpool-II-95.service entered failed state.</b></span></p>
<p class="gmail-p1"><span class="gmail-s2">Feb 05 13:50:22 pgpool systemd[1]: <b>pgpool-II-95.service failed.</b></span></p><p class="gmail-p1"><span class="gmail-s2"><b><br></b></span></p><p class="gmail-p1"><span class="gmail-s2"><b><br></b></span></p></div><div>
<p class="gmail-p1"><span class="gmail-s1">017-02-05 13:52:35: pid 2543: FATAL: failed to bind a socket: "/tmp/.s.PGSQL.5432"</span></p>
<p class="gmail-p1"><span class="gmail-s1">2017-02-05 13:52:35: pid 2543: DETAIL: bind socket failed with error: "Address already in use"</span></p><div>I restarted it-- > no luck</div><div>I'm on centos 7. I read somethings about startup script but have no clue about them.</div><div>Your help is appritiated.</div><br>
</div></div>