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.