Re: Permissions to users ??? (FATAL: Ident authentication failed for user) - Mailing list pgsql-novice

"Ronni" <rofe@mailme.dk> writes:
> I then created a database called wt, and added the following to pg_hba.conf:
> host    wt          wt_admin    127.0.0.1/32          md5
> host    wt          wt_public   127.0.0.1/32          md5

> Then restarted postgresql and tried to login with:
> psql -U wt_admin -W wt
> but I get the following error:
> psql: FATAL:  Ident authentication failed for user "wt_admin"

Where did you put those lines in the pg_hba file?  I'll bet they are
after a more general line that specifies ident authorization.  pg_hba
is order-sensitive, see the docs.

            regards, tom lane