Re: probable pg_hba.conf configuration issues - Mailing list pgsql-general

From Sim Zacks
Subject Re: probable pg_hba.conf configuration issues
Date
Msg-id 536A47FA.4010700@compulab.co.il
Whole thread Raw
In response to probable pg_hba.conf configuration issues  (Ravi Roy <ravi.aroy@gmail.com>)
List pgsql-general
<div class="moz-cite-prefix">My bet is you have either another line in the pg_hba that says trust<br /> or you saved
thepassword 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@mail.gmail.com"type="cite"><div
dir="ltr"><div>Hi,</div><div> </div><div>I'msorry if this question have been asked earlier, but i could not find any
validresult through googling.</div><div> </div><div>I'm running postgresql 9.1 on Windows 7 (64 bit) and i've following
configurationin pg_hba.conf.</div><div> </div><div>host     all             superuser1    <a href="http://127.0.0.1/32"
moz-do-not-send="true">127.0.0.1/32</a>    password<br /> host     all             normaluser1  <a
href="http://127.0.0.1/32"moz-do-not-send="true">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 localconnections, remote connections to database are disabled)</div><div> </div><div>But if I try to connect
usingpgadmin (from the same machine) it gives acess to database without password, i'm surprised as it does not seem to
respectpg_hba.conf or i'm terribly wrong in the configuration somewhere. </div><div> </div><div>Does somebody have any
ideawhat 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/> 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: probable pg_hba.conf configuration issues
Next
From: David G Johnston
Date:
Subject: Re: probable pg_hba.conf configuration issues