<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
text="#000000">
<div class="moz-cite-prefix">My bet is you have either another line
in the pg_hba that says trust<br>
or you saved the password and forgot.<br>
<br>
Sim<br>
<br>
On 05/07/2014 05:33 PM, Ravi Roy wrote:<br>
</div>
<blockquote
cite="mid:CAFMBnF_UHtTyucMxquDE0Sd5siy3NHERGiRKC3YkGT8xs1=e_Q(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div>Hi,</div>
<div> </div>
<div>I'm sorry if this question have been asked earlier, but i
could not find any valid result through googling.</div>
<div> </div>
<div>I'm running postgresql 9.1 on Windows 7 (64 bit) and i've
following configuration in pg_hba.conf.</div>
<div> </div>
<div>host all superuser1 <a
moz-do-not-send="true" href="http://127.0.0.1/32">127.0.0.1/32</a>
password<br>
host all normaluser1 <a
moz-do-not-send="true" href="http://127.0.0.1/32">127.0.0.1/32</a>
password</div>
<div> </div>
<div>Using command line : psql -U superuser1 & psql -U
normaluser1 asks for password and login successfully. -
perfect. (We are only alloing local connections, remote
connections to database are disabled)</div>
<div> </div>
<div>But if I try to connect using pgadmin (from the same
machine) it gives acess to database without password, i'm
surprised as it does not seem to respect pg_hba.conf or i'm
terribly wrong in the configuration somewhere. </div>
<div> </div>
<div>Does somebody have any idea what is wrong? </div>
<div> </div>
<div>Thank you</div>
<div> </div>
<div>Ravi.</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
</div>
</blockquote>
<br>
</body>
</html>