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

From Ravi Roy
Subject probable pg_hba.conf configuration issues
Date
Msg-id CAFMBnF_UHtTyucMxquDE0Sd5siy3NHERGiRKC3YkGT8xs1=e_Q@mail.gmail.com
Whole thread Raw
Responses Re: probable pg_hba.conf configuration issues
Re: probable pg_hba.conf configuration issues
Re: probable pg_hba.conf configuration issues
List pgsql-general
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.
 
 
 
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server process crash - Segmentation fault
Next
From: Tom Lane
Date:
Subject: Re: probable pg_hba.conf configuration issues