Обсуждение: a problem with pg_hba.conf

Hello
I have installed without problem 8.2.4, but I must have missed something
in my pg_hba.conf file.
I want all users, from anywhere even the local host, to connect using a
password.
So I did:
# my pg_hba file
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5
# my machine different of db server
host    all         all         156.148.120.63/32      md5
# internet
host    all         all        0.0.0.0/0             reject

Now if I do:
psql -U myself -h dbmachine mydb
---> no password required

psql -U myself -h dbmachine.crs4.it mydb
---> password required

Why ? I want the password required even if I am not giving the full name
of the machine. What am I doing wrong ?
I have been googling around, but could not find an answer.
Thanks for any pointers
P.

On Wed, Sep 19, 2007 at 03:02:26PM +0200, Patricia Rodriguez Tome wrote:
> Hello
> I have installed without problem 8.2.4, but I must have missed something
> in my pg_hba.conf file.
> I want all users, from anywhere even the local host, to connect using a
> password.

Did you reload the postmaster after making the changes?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.