Re: pg_hba.conf and ident authentification - Mailing list pgsql-admin

Jozef KRSSAK writes:

> 4. name of my account:
> krssak
>
> 5. pg_hba.conf:
> local   rocnikovy                                       trust
> host    rocnikovy       127.0.0.1       255.255.255.255 ident   map
>
> 6. pg_ident.conf:
> map     krssak  jozok
>
> 7. create user jozok;

> 9.
> krssak@pec:~$ psql -h localhost -d rocnikovy
> Connection to database 'rocnikovy' failed.
> IDENT authentication failed for user 'krssak'

You need to instruct psql to connect as database user 'jozok'.  Otherwise
it will default to 'krssak' and your careful setup is for nought.  See
option '-u'.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/