[pgpool-general: 7704] Re: PGPool-II 4.2.3 on CentOS 7.9: PCP Commands are ignoring .pcppass file
Bo Peng
pengbo at sraoss.co.jp
Mon Sep 13 17:45:42 JST 2021
Hello,
> subject says all, I'm getting crazy trying to understand why pcp commands
> are completely ignoring .pcppass file.
>
> The command is:
>
> pcp_watchdog_info -h 1.1.1.1 -p 9898 -U pgpool
You need to use "-w" or "--no-password" option.
pcp_watchdog_info -w -h 1.1.1.1 -p 9898 -U pgpool
[Doc]
https://www.pgpool.net/docs/latest/en/html/pcp-common-options.html
> I'm sure the file is correct, I've also tried to use strace and from the
> output there is no attempt to open $HOME/.pcppass file.
>
> I've tried with user root and user postgres:
>
> # ls -l /root/.pcppass /var/lib/pgsql/.pcppass
> -rw------- 1 root root 44 Sep 10 13:06 /root/.pcppass
> -rw------- 1 postgres postgres 83 Jul 17 09:42 /var/lib/pgsql/.pcppass
>
> The command is:
>
> pcp_watchdog_info -h 1.1.1.1 -p 9898 -U pgpool
>
> The file contains:
> 1.1.1.1:9898:pgpool:redactedpassword
>
> What am I doing wrong?
>
> Thanks in advance
> Regards
> Luca
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/
More information about the pgpool-general
mailing list