<div dir="ltr">Hello,<div>We use pgpool for load balancing two postgres databases that has replicated using streaming replication. I've only enabled load balancing feature and other options are off.</div><div>When I'm trying to restart pgpool with systemctl I get an error like this:</div><div><br></div><div><div>Aug 20 14:34:40 Beta pgpool[16184]: [16184] [No Connection]@[No Connection] FATAL: failed to bind a socket: "/tmp/.s.PGSQL.5432"</div><div>Aug 20 14:34:40 Beta pgpool[16184]: [16184] [No Connection]@[No Connection] DETAIL: bind socket failed with error: "Address already in use"</div></div><div><br></div><div>Seems like pgpool can not delete it's socket files so after being stopped it can't start. But socket files have full permissions:</div><div><div>srwxrwxrwx 1 postgres postgres 0 Aug 20 14:24 /tmp/.s.PGSQL.5432</div><div>srwxrwxrwx 1 postgres postgres 0 Aug 20 14:24 /tmp/.s.PGSQL.9898</div></div><div><br></div><div>I've attached my configuration file.</div><div><div>This is pgpool version I'm using which latest version if Ubuntu 16.04 apparently.</div><div>pgpool-II version 3.4.3 (tataraboshi)</div></div><div><div><br></div><div>Have I configured something wrong or I've to install latest version?</div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Live long and prosper,<div><a href="http://k1h.ir/" target="_blank">K1.H</a></div></div></div></div></div>
</div></div>