[pgpool-general: 5529] Problem with PCP socket directory setting

Jeremiah Penery jpenery at redskytech.com
Wed May 24 00:34:48 JST 2017


I'm using the latest pgpool RPMs: pgpool-II-pg96-3.6.4-1pgdg.rhel6.x86_64

There seems to be some problem with the PCP socket directory setting.  I have it set as such:
pcp_socket_dir = '/var/run/postgresql'

The file is indeed created in that directory:
[root at jp1 redsky]# locate 9898
/var/run/postgresql/.s.PGSQL.9898

However, if I try to run some pcp command (e.g. pcp_node_info) without giving a host parameter, it seems to always want to use /tmp for the socket directory:

[root at jp1]# pcp_node_info -U admin -n 0
Password:
ERROR: connection to socket "/tmp/.s.PGSQL.9898" failed with error "No such file or directory"

If I provide the host parameter, it works fine, because I guess it's going over the network instead of using the socket file.

[root at jp1 ]# pcp_node_info -U admin -h localhost -n 0
Password:
192.168.20.175 5433 2 1.000000 up

Thanks,
Jeremiah


More information about the pgpool-general mailing list