pg_hba.conf and password files

From: Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: pg_hba.conf and password files
Date: 2001-08-07 09:26:09
Message-ID: 01080711260900.11458@jumbo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,

I use a pg_hba.conf like this:

local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 134.93.64.0 255.255.255.0 password usr.txt

In usr.txt I made one entry "test:test". When I connect with Access, the DSN
dialog appears, and I enter "test" and "test" in the corresponding fields for
username and password. The connect fails, and the postgres.log says: "user
'wagner' not found in password file". It seems that the username "test" does
not make it to the backend, and my Windows username "wagner" is sent instead.

Any hints?

Thanks,

Markus

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Gary Stainburn 2001-08-07 10:51:27 Re: pg_hba.conf and password files
Previous Message FutureSoft 2001-08-06 19:24:35 PostgreSQL ODBC Driver