[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