Re: pg_hba.conf and ident authentification

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(at)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(at)gmx(dot)net http://yi.org/peter-e/