| From: | Niral Trivedi <niral(dot)trivedi(at)insage(dot)com> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | problem with pg_hba.conf |
| Date: | 2000-12-13 21:24:38 |
| Message-ID: | 328DC4EC2C9B74428D8DAED1931285BF10D954@FLAN-EXCH01.corp.insage.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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!!! I have
already commented out the default 'local all trust' line!!!!
Can anybody give some suggestions on this??
Thanks in advance..
Niral
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dr. Hans-Christian Waldmann | 2000-12-14 10:22:27 | need libs for pgperl for AIX 4.3.3 |
| Previous Message | Peter Eisentraut | 2000-12-13 19:33:52 | Re: |