Re: [GENERAL] probable pg_hba.conf configuration issues

[Sim Zacks]

My bet is you have either another line in the pg_hba that says trust or you saved the password and forgot. Sim On 05/07/2014 05:33 PM, Ravi Roy wrote: Hi,   I'm sorry if this question have been asked earlier, but i could not find any valid result through googling.   I'm running postgresql 9.1 on Windows 7 (64 bit) and i've following configuration in pg_hba.conf.   host     all             superuser1    127.0.0.1/32     password host     all             normaluser1  127.0.0.1/32     password   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)   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.   Does somebody have any idea what is wrong?   Thank you   Ravi.