Postgres Pro
Downloads
Home   >   mailing lists

hba_conf: only first line is checked - Mailing list pgsql-admin

From Cédric Mesnil
Subject hba_conf: only first line is checked
Date
Msg-id 3A706F2D.4A912000@trusted-logic.fr
Whole thread Raw
Responses Re: hba_conf: only first line is checked  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hi all,

My probleme is the following:
I want to allow some user to connect to my db with password authentication against
a first password file and allow other user against  a second one. I ve writen  the following pg_hba.conf:

host           all   192.168.1.201   255.255.255.255       password passwd
host           all   192.168.1.201   255.255.255.255       password passwd2

the Problem is if the user is present in the second password file, he is always rejected.
(If i comment the first line in the hba.conf, it works)

Is anyone have a solution?

Tanks a lot

Cedric
Attachment

pgsql-admin by date:

Previous
From: geny.matsui@promon.com.br
Date:
Subject: How many memory a backend process use ?
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: md_open problem