<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:"Trebuchet MS"}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal">When I try to connect to PostgreSQL via pgpoo, pgpool is <b>
not asking me</b> for password. It just throws the error </p>
<p class="MsoNormal">psql: ERROR: "MD5" authentication with pgpool failed for user "postgres"</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">My pg_hba.conf gor postgresql is
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># TYPE DATABASE USER ADDRESS METHOD</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">#</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># # "local" is for Unix domain socket connections only</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># # IPv4 local connections:</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">host all all 192.0.0.1/8 md5</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># # IPv6 local connections:</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># host all all ::1/128 trust</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># # Allow replication connections from localhost, by a user with the</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># # replication privilege.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">local replication postgres trust</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">host replication postgres 127.0.0.1/32 trust</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">host replication postgres ::1/128 trust
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">pool_hba.conf reads –
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># "local" is for Unix domain socket connections only</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"># IPv4 local connections:</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">host all all 192.0.0.1/8 md5</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Any idea why?</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Pgpool version is pgpool-II-3.2.4</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Regards,</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt; font-family:"Trebuchet MS","sans-serif"; color:black">Jayadevan
</span></p>
<p class="MsoNormal"> </p>
</div>
<br>
<br>
DISCLAIMER: <font color="#999999" size="1" face="Tahoma">"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in
error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not
liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."</font><br>
<font size="1"></font>
</body>
</html>