[pgpool-general: 9037] Re: cannot get .pgppass file to work
Bo Peng
pengbo at sraoss.co.jp
Fri Mar 1 17:37:50 JST 2024
Hi,
> $ cat ~/.pcppass
> *:5432:postgres:postgres
>
>
> $ pcp_node_info -w -p 5440 -U postgres -n 1
It seems that the port is different.
In pcp command you use 5440, but in .pcppass 5432 is specified.
On Thu, 29 Feb 2024 22:55:17 -0700
Sbob <sbob at quadratum-braccas.com> wrote:
> 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
>
>
>
>
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/
More information about the pgpool-general
mailing list