pg_hba.conf confusion

From: "David M(dot) Kaplan" <dmkaplan(at)ucdavis(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_hba.conf confusion
Date: 2002-06-18 03:47:27
Message-ID: 3D0EAD4F.9060305@ucdavis.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lee Kindness 2002-06-18 11:02:30 ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)
Previous Message Josh Goldberg 2002-06-17 22:39:39 referential integrity through inherited tables