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
>
>
>
>
>
>
>