Re: probable pg_hba.conf configuration issues
От | Sim Zacks |
---|---|
Тема | Re: probable pg_hba.conf configuration issues |
Дата | |
Msg-id | 536A47FA.4010700@compulab.co.il обсуждение исходный текст |
Ответ на | probable pg_hba.conf configuration issues (Ravi Roy <ravi.aroy@gmail.com>) |
Список | 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 по дате отправления: