[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