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" <[EMAIL PROTECTED]> wrote in message news:a555sr$1qnc$[EMAIL PROTECTED].; > 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 > > > > > > > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
