Thread: Problem with authentication in psql.

Hi everybody,
   I have some problem with the Postgres user authentication. A user
with password was created by me, but when I tried to enter in psql using
that user I received a fail mesage.

$ psql -W template1 pagano
Password:
psql: Peer authentication failed for user 'pagano'
   Anybody knows what is happening?

Thanks for all.                           Vitalino.

Vitalino writes:

>     I have some problem with the Postgres user authentication. A user
> with password was created by me, but when I tried to enter in psql using
> that user I received a fail mesage.
>
> $ psql -W template1 pagano
> Password:
> psql: Peer authentication failed for user 'pagano'

Official PostgreSQL sources don't have peer authentication.  You should
contact the provider of your package (Debian?).

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter