[pgpool-general: 7092] [HELP ] Unable to connect to pgpool

[Praveen Kumar K S]

Hello,

I'm getting below error when trying to connect to pgpool.

>From different VM:
praveen at master:~$ psql -U postgres -h 10.128.0.6 -p 9999
psql: ERROR:  failed to authenticate with backend using md5
DETAIL:  valid password not found

>From pgpool VM:
root at pgpool-1:/usr/local/etc# createdb -p 9999 test
createdb: could not connect to database template1: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9999"?

Below are some outputs:
root at pgpool-1:/usr/local/etc# pcp_node_info -v -h localhost -U postgres 0
Password:
Hostname               : 10.128.0.4
Port                   : 5432
Status                 : 2
Weight                 : 0.500000
Status Name            : up
Role                   : primary
Replication Delay      : 0
Replication State      :
Replication Sync State :
Last Status Change     : 2020-06-09 12:10:03

root at pgpool-1:/usr/local/etc# pcp_node_info -v -h localhost -U postgres 1
Password:
Hostname               : 10.128.0.5
Port                   : 5432
Status                 : 2
Weight                 : 0.500000
Status Name            : up
Role                   : standby
Replication Delay      : 0
Replication State      :
Replication Sync State :
Last Status Change     : 2020-06-09 12:10:03

Please let me know what could be wrong.

-- 


*Regards,*


*K S Praveen Kumar*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20200609/cbcbe710/attachment.htm>