[pgpool-general: 7093] Re: [HELP ] Unable to connect to pgpool

[Praveen Kumar K S]

Hello,

It was a configuration issue. Now I'm able to connect.

On Tue, Jun 9, 2020 at 6:45 PM Praveen Kumar K S <praveenssit at gmail.com>
wrote:

> 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*
>


-- 


*Regards,*


*K S Praveen KumarM: +91-9986855625 *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200609/fce3d275/attachment-0001.html>