[pgpool-general: 5608] failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"

[Yong Zhang]

Does anyone have the same issue with mine?

OS: Ubuntu16.04
Pgpool2:  3.6.4-1.pgdg16.04+1
PostgreSQL:  9.6.3-1.pgdg16.04+1

Pgpool2 service is controlled by systemd.

Issues:

  1.  “Systemctl stop pgpool2” will take a long time and finally will be failed
  2.  “systemctl start pgpool2” will have below errors in logs:

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"

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"

Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED

Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Unit entered failed state.

Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Failed with result 'exit-code'.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170704/1a1580df/attachment.html>