Re: Client Authentication

I was having the same problem. In pg_hba.conf I had the following lines:

local all password .superusers
local design password .pg_design

I switched the order of the lines so that the "local all" was last and that
fixed the problem

local design password .pg_design
local all password .superusers

I don't know if that will help you out or not.

Craig


"Gtrica" <gtricarico@intin.it> wrote in message
news:a555sr$1qnc$1@jupiter.hub.org...
> Hi all
>
> I'm trying to configure Postgress to allow restricted access to database.
> I inserted in the file pg_hba.conf the following line:
> local   primo
> password   ./pass
>
> the file pass in directory  "data" contains the line "giuseppe:gitrica"
> when I connect using "psql primo giuseppe" I'm asked to insert the
password
> but it tells
> "Password authentication failed for user 'giuseppe' "
>
> Giuseppe
>
>
>
>
>
>
>