Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group