RE: Problem with pg_hba.conf

Tom,

I have that 'local all trust' line commented out. And there is no other
entry in the file at all...

And what do you exactly mean by connecting via IP??? I assume that I am
connecting through UNIX socket because when I commented out the
local    db1    crypt file1.dat
local    db2    crypt file2.dat

and added following line :
host db1    MY_IP_ADDRESS    MASK    crypt file1.dat

It gave me following error:
DBI->connect failed: No pg_hba.conf entry for host localhost, user username,
database db1
 at ./dbTest.pl line 9

Any idea???

TIA

Niral

> 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

That looks correct as far as it goes.

> But problem is I can connect to both db using both password.

Are you sure the postmaster is checking the password at all?  It sounds
to me like the postmaster might be selecting some earlier entry in
pg_hba.conf and not using these two.  Did you comment out the default
entry for "local all trust"?  Are you perhaps connecting via IP, rather
than via a Unix socket?

            regards, tom lane