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(at)intin(dot)it> wrote in message
news:a555sr$1qnc$1(at)jupiter(dot)hub(dot)org(dot)(dot)(dot)
> 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
>
>
>
>
>
>
>