<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">The hint is accurate, it’s definitely an access issue. pg_hba.conf files deserve another look at for both your master and slave nodes. Try to connect from your pgpool server to each postgres server databases separately with port 5432 (regular psql connection) to see if it works.<div class=""><br class=""></div><div class="">If that works properly I’d tail both the pgpool and the postgres connection to see if there’s any errors that popup when you try a psql connection via port 9999.</div><div class=""><div class=""><br class=""></div><div class=""><br class=""></div><div class="">If you haven’t already start pgpool with error output logs. I have my pool start command alias to “/usr/local/bin/pgpool -f /usr/local/etc/pgpool.conf -F /usr/local/etc/pcp.conf -n -d > /tmp/pgpool.log 2>&1 &”. This way I can tail the errors properly.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Hope that helps.</div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Jan 31, 2016, at 1:28 AM, Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" class="">giles.gomes@retailephant.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi Keit,<div class=""><br class=""></div><div class="">Thanks for you reply. I have tried in your way but following error is showing both with 'apache' and 'postgres' user.</div><div class=""><br class=""></div><div class=""><div class="">$ psql -h test001pgp01 -U apache -p 9999 -W postgres</div><div class="">Password for user apache:</div><div class="">psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.</div><div class="">HINT: check pg_hba.conf</div><div class=""><br class=""></div><div class="">$ psql -h test001pgp01 -U postgres -p 9999 -W postgres</div><div class="">Password for user postgres:</div><div class="">psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.</div><div class="">HINT: check pg_hba.conf</div></div><div class=""><br class=""></div><div class="">Regards,</div><div class="">Giles.</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On 30 January 2016 at 05:22, kiet.h.lieng <span dir="ltr" class=""><<a href="mailto:kiet.h.lieng@gmail.com" target="_blank" class="">kiet.h.lieng@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div class="">Just to expand on this PGPool is categorized as “middleware” this is the correct term but it’s not constructive on how it’s used and how you’re supposed to interact with it. Just that it sits between the client and actual database.</div><div class=""><br class=""></div><div class="">To put it plainly: pgpool lives “inside” postgres and the only way you interact with pgpool is through the same postgresql connection call BUT with the pgpool port number specified in your pgpool.conf file (search for port setting).</div><div class=""><br class=""></div><div class="">Something like "psql -h pgpoolhostname -U someuser -p 9999 -W postgres” where 9999 is the port of the pgpool connection.</div><div class=""><br class=""></div><div class="">Let me know if this is not clear enough and I’ll try to explain it better. </div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Thanks.</div><div class=""><div class="h5"><div class=""><br class=""></div><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jan 28, 2016, at 5:52 AM, Dang Minh Huong <<a href="mailto:kakalot49@gmail.com" target="_blank" class="">kakalot49@gmail.com</a>> wrote:</div><br class=""><div class=""><div style="word-wrap:break-word" class="">Hi,<div class=""><br class=""></div><div class=""><span style="font-family:HelveticaNeue" class="">You can connect to database </span>through pgpool-II with<font face="HelveticaNeue" class=""> port which is defined in pgpool.conf (parameter “port").</font></div><div class=""><span style="font-family:HelveticaNeue" class="">Take a look at manual, there are several parameters you also need to configure too.</span><div style="font-family:HelveticaNeue" class=""><br class=""></div><div style="font-family:HelveticaNeue" class=""><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#config" target="_blank" class="">http://www.pgpool.net/docs/latest/pgpool-en.html#config</a></div><div style="font-family:HelveticaNeue" class=""><br class=""></div><div style="font-family:HelveticaNeue" class="">Best regards,</div><div style="font-family:HelveticaNeue" class="">bocap</div><div class=""><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jan 28, 28 Heisei, at 17:46, Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" target="_blank" class="">giles.gomes@retailephant.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class="">Hello Tatsuo,<div class=""><br class=""></div><div class="">I have install pgpool and pgpoolAdmin in one server and there is two database servers under this pgpool server, one working as Primary and another as Standby. Replication is working fine.</div><div class=""><br class=""></div><div class="">Please let me know how I can connect postgresql database through pgpool.<br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class="">Best regards,<div class="">Giles Cornelius Gomes</div><div class="">Database Administrator</div><div class="">Impel IT Solutions Ltd.</div><div class="">Phone: +88 01 714329389 </div></div></div></div></div>
</div></div>
_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" target="_blank" class="">pgpool-general@pgpool.net</a><br class=""><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank" class="">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br class=""></div></blockquote></div><br class=""></div></div></div></div>_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" target="_blank" class="">pgpool-general@pgpool.net</a><br class=""><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank" class="">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br class=""></div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class="">Best regards,<div class="">Giles Cornelius Gomes</div><div class="">Database Administrator</div><div class="">Impel IT Solutions Ltd.</div><div class="">Phone: +88 01 714329389 </div></div></div></div></div>
</div>
</div></blockquote></div><br class=""></div></div></body></html>