<div dir="ltr">Hi Keit,<div><br></div><div>Thanks for you reply. I have tried in your way but following error is showing both with 'apache' and 'postgres' user.</div><div><br></div><div><div>$ psql -h test001pgp01 -U apache -p 9999 -W postgres</div><div>Password for user apache:</div><div>psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.</div><div>HINT: check pg_hba.conf</div><div><br></div><div>$ psql -h test001pgp01 -U postgres -p 9999 -W postgres</div><div>Password for user postgres:</div><div>psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.</div><div>HINT: check pg_hba.conf</div></div><div><br></div><div>Regards,</div><div>Giles.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 30 January 2016 at 05:22, kiet.h.lieng <span dir="ltr"><<a href="mailto:kiet.h.lieng@gmail.com" target="_blank">kiet.h.lieng@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>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><br></div><div>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><br></div><div>Something like "psql -h pgpoolhostname -U someuser -p 9999 -W postgres” where 9999 is the port of the pgpool connection.</div><div><br></div><div>Let me know if this is not clear enough and I’ll try to explain it better. </div><div><br></div><div><br></div><div>Thanks.</div><div><div class="h5"><div><br></div><br><div><blockquote type="cite"><div>On Jan 28, 2016, at 5:52 AM, Dang Minh Huong <<a href="mailto:kakalot49@gmail.com" target="_blank">kakalot49@gmail.com</a>> wrote:</div><br><div><div style="word-wrap:break-word">Hi,<div><br></div><div><span style="font-family:HelveticaNeue">You can connect to database </span>through pgpool-II with<font face="HelveticaNeue"> port which is defined in pgpool.conf (parameter “port").</font></div><div><span style="font-family:HelveticaNeue">Take a look at manual, there are several parameters you also need to configure too.</span><div style="font-family:HelveticaNeue"><br></div><div style="font-family:HelveticaNeue"><a href="http://www.pgpool.net/docs/latest/pgpool-en.html#config" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#config</a></div><div style="font-family:HelveticaNeue"><br></div><div style="font-family:HelveticaNeue">Best regards,</div><div style="font-family:HelveticaNeue">bocap</div><div><div><br><div><blockquote type="cite"><div>On Jan 28, 28 Heisei, at 17:46, Giles Gomes <<a href="mailto:giles.gomes@retailephant.com" target="_blank">giles.gomes@retailephant.com</a>> wrote:</div><br><div><div dir="ltr">Hello Tatsuo,<div><br></div><div>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><br></div><div>Please let me know how I can connect postgresql database through pgpool.<br clear="all"><div><br></div>-- <br><div><div dir="ltr"><div><div dir="ltr">Best regards,<div>Giles Cornelius Gomes</div><div>Database Administrator</div><div>Impel IT Solutions Ltd.</div><div>Phone: +88 01 714329389 </div></div></div></div></div>
</div></div>
_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div></blockquote></div><br></div></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div></blockquote></div><br></div></div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Best regards,<div>Giles Cornelius Gomes</div><div>Database Administrator</div><div>Impel IT Solutions Ltd.</div><div>Phone: +88 01 714329389 </div></div></div></div></div>
</div>