Problem with pg_hba.conf

From: Niral Trivedi <niral(dot)trivedi(at)insage(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Problem with pg_hba.conf
Date: 2000-12-13 15:21:58
Message-ID: 328DC4EC2C9B74428D8DAED1931285BF10D94D@FLAN-EXCH01.corp.insage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

I have already posted this message yesterday but didn't get any reply yet...
Please help me with this..I am having trouble doing db authentication with
'pg_hba.conf' file..

I have added two users using 'CREATE USER' command for a db. And then I have
created two separated password file to do authentication to two different db
in the system.

Also, I have added separate lines in 'pg_hba.conf' file for two db as
follows:

local db1 crypt file1.dat
local db2 crypt file2.dat

But problem is I can connect to both db using both password. What I supposed
to get is, I can connect to 'db1' only with username in 'file1.dat' and
'db2' with username in 'file2.dat'. But that is not happening!!!

Can anybody give some suggestions on this??

Thanks in advance..

Niral

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2000-12-13 15:25:41 Re: info please
Previous Message Nathan Barnett 2000-12-13 15:05:46 RE: Reliability Stability of PgSQL & it's JDBC driver