Re: probable pg_hba.conf configuration issues

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.