[pgpool-general: 4582] Using pcp_ command without password

Alexandre Ellert ellertalexandre at gmail.com
Tue Mar 29 19:36:26 JST 2016


Hello,

My setup is a 2 nodes cluster with pgpool 3.5 / postgresql 9.5.
I try to use a some pcp_ command in a script but can’t figure how to get it working.

postgres at postgres-prod-1:~$ pcp_node_info 0 -w
FATAL:  authentication failed for user "postgres"
DETAIL:  username and/or password does not match

postgres at postgres-prod-1:~$ cat $HOME/.pcppass 
postgres-prod-1.ivscloud.local:9898:postgres:PASSSWORD

I tried the old way to pass user/password to pcp without success :
postgres at postgres-prod-1:~$ pcp_node_info 0 postgres PASSWORD
pcp_node_info: Warning: extra command-line argument "postgres" ignored
pcp_node_info: Warning: extra command-line argument "PASSWORD" ignored

I’m 100% sure my password is correct and pgpool is listening correctly on port 9898
What is my mystake ?

Thank you

Alexandre




More information about the pgpool-general mailing list