[pgpool-general: 4583] Re: Using pcp_ command without password

Abel Martín abel.martin.ruiz at gmail.com
Tue Mar 29 20:04:55 JST 2016


Hi,

The syntax for PCP has changed since version 3.5.0. Use --help to
check the new syntax.

http://pgpool.net/mediawiki/index.php?title=pgpool-II_3.5_features&redirect=no#PCP_system_overhauling
http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_common_options

Cheers,
Abel Martin

2016-03-29 12:36 GMT+02:00 Alexandre Ellert <ellertalexandre at gmail.com>:
> 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
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list