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

[Tatsuo Ishii]

> 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:

You need to give -w (lower case w) option to the pcp commands.

https://www.pgpool.net/docs/44/en/html/pcp-common-options.html

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp