[pgpool-general: 8602] pcp commands not detecting .pcppass file

Ron ronljohnsonjr at gmail.com
Wed Feb 15 02:44:40 JST 2023


PgPool 4.3.3 installed from Postgresql RPMs

Here I have a .simple .pcppass file (permissions 0600) with one entry, for 
user "foo" with password "bar".  I know that correct MD5 hash for "bar" is 
in /etc/pgpool-II/pcp.conf, because pcp_* commands accept "bar" (without 
quotes) when prompting me for a password.

Why aren't pcp_* programs reading my ~/.pcppass file, even though I seem to 
have followed the instructions in 
https://www.pgpool.net/docs/43/en/html/pcp-commands.html?


$ dir ~/.pcppass
-rw------- 1 postgres postgres 85 2023-02-14 11:26:54 .pcppass

$ hostname
FISPTAPPGS405a

$ cat ~/.pcppass
# hostname:port:username:password
localhost:9898:foo:bar
FISPTAPPGS405a:9898:foo:bar

$ pcp_proc_count -v -U foo
Password:
No       |       PID
_____________________
0        |       1198065
1        |       1198066
2        |       1198064
3        |       1198063

Total Processes:4


-- 
Born in Arizona, moved to Babylonia.


More information about the pgpool-general mailing list