[pgpool-general: 9033] cannot get .pgppass file to work

[Sbob]

All;


I cannot get .pcppass file to work


I setup my pcp.conf file to have the following:


$ pg_md5 postgres
e8a48653851e28c69d0506508fb27fc5



$ cat /etc/pgpool-II/pcp.conf
# USERID:MD5PASSWD
postgres:e8a48653851e28c69d0506508fb27fc5



$ cat ~/.pcppass
*:5432:postgres:postgres


$ chmod 0600 ~/.pcppass

$ export  PCPPASSFILE=/var/lib/pgsql/.pcppass


$ pcp_node_info -w -p 5440 -U postgres -n 1
FATAL:  authentication failed for user "postgres"
DETAIL:  username and/or password does not match



However passing in a pw works (using the password:  postgres)

$ pcp_node_info -W -p 5440 -U postgres -n 1
Password:
172.16.108.161 5432 2 0.333333 up up primary primary 0 none none 
2024-02-29 22:22:40



what am I doing wrong?


Thanks in advance