[pgpool-general: 9033] cannot get .pgppass file to work
Sbob
sbob at quadratum-braccas.com
Fri Mar 1 14:55:17 JST 2024
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
More information about the pgpool-general
mailing list