Hi,
I recently experienced a weird bug with postgresql. I am running:
postgresql-7.2.1-8
postgresql-server-7.2.1-5
I was trying to connect to a database on a my machine from another
machine. Initially, my pg_hba.conf looked like:
host all 127.0.0.1 0.0.0.0 ident sameuser
host all 192.168.1.2 255.255.255.128 password
where my machine is 192.168.1.1 and the client is 192.168.1.2.
Connecting using psql -h 192.168.1.1 failed stating:
FATAL 1: IDENT authentification failed for user 'me'
Then I changed the order of the lines in my configuration file:
host all 192.168.1.2 255.255.255.128 password
host all 127.0.0.1 0.0.0.0 ident sameuser
Now the connection worked without problems. In the first case, it seems
to be trying to use IDENT authentification, even though that should only
apply to localhost.
David K.
