<div dir="ltr"><div>Hello,</div><div><br></div><div>It was a configuration issue. Now I'm able to connect.<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 9, 2020 at 6:45 PM Praveen Kumar K S <<a href="mailto:praveenssit@gmail.com">praveenssit@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hello,</div><div><br></div><div>I'm getting below error when trying to connect to pgpool. <br></div><div><br></div><div>From different VM:<br></div><div>praveen@master:~$ psql -U postgres -h 10.128.0.6 -p 9999<br>psql: ERROR: failed to authenticate with backend using md5<br>DETAIL: valid password not found<br></div><div><br></div><div>From pgpool VM:</div><div>root@pgpool-1:/usr/local/etc# createdb -p 9999 test<br>createdb: could not connect to database template1: could not connect to server: No such file or directory<br> Is the server running locally and accepting<br> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9999"?</div><div><br></div><div>Below are some outputs:<br></div><div>root@pgpool-1:/usr/local/etc# pcp_node_info -v -h localhost -U postgres 0<br>Password: <br>Hostname : 10.128.0.4<br>Port : 5432<br>Status : 2<br>Weight : 0.500000<br>Status Name : up<br>Role : primary<br>Replication Delay : 0<br>Replication State : <br>Replication Sync State : <br>Last Status Change : 2020-06-09 12:10:03</div><div><br></div><div>root@pgpool-1:/usr/local/etc# pcp_node_info -v -h localhost -U postgres 1<br>Password: <br>Hostname : 10.128.0.5<br>Port : 5432<br>Status : 2<br>Weight : 0.500000<br>Status Name : up<br>Role : standby<br>Replication Delay : 0<br>Replication State : <br>Replication Sync State : <br>Last Status Change : 2020-06-09 12:10:03<br></div><div><br></div><div>Please let me know what could be wrong.</div><div><br></div><div>-- <br><div dir="ltr"><font style="font-family:courier new,monospace" size="1"><b style="color:rgb(102,102,102)">Regards,<br><br></b></font><div style="color:rgb(102,102,102)"><font size="1"><b><font face="'comic sans ms', sans-serif"><font style="font-family:courier new,monospace" size="1">K S Praveen Kumar<br></font><br></font></b></font></div></div></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><font style="font-family:courier new,monospace" size="1"><b style="color:rgb(102,102,102)">Regards,<br><br></b></font><div style="color:rgb(102,102,102)"><font size="1"><b><font face="'comic sans ms', sans-serif"><font style="font-family:courier new,monospace" size="1">K S Praveen Kumar<br>M: +91-9986855625 </font><br></font></b></font></div></div>