Niral Trivedi <niral.trivedi@insage.com> writes:
> 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
