Skip site navigation (1) Skip section navigation (2)

Permissions to users ??? (FATAL: Ident authentication failed for user)

From: "Ronni" <rofe(at)mailme(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Permissions to users ??? (FATAL: Ident authentication failed for user)
Date: 2006-03-11 19:26:21
Message-ID: 2864. (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

Im about to make a small webapplication using Postgresql.

My system is Debian 3.1 Sarge with Postgresql 8.1 from

What I want to do is have my superuser, which also have a system account,
to create a database called wt, and then create two users (wt_public,
wt_admin) for use in the webapplication.

The two users for the webapplication should then have to following
wt_public: only have permission to do a select, nothing else.
wt_admin: have all permissions on the database wt incl. creating and
dropping tables etc.

I've installed Postgresql and created my own superuser, and then, using my
superuser, I created the two users (wt_public, wt_admin)

I then created a database called wt, and added the following to pg_hba.conf:
host    wt          wt_admin          md5
host    wt          wt_public          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"

I have spent quite some time searching the net, reading and so on, but
cant seem to find anyting usefull on out how to give my users access to
the database.

All help is appriciated.



pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-11 22:03:34
Subject: Re: Permissions to users ??? (FATAL: Ident authentication failed for user)
Previous:From: Andreas KretschmerDate: 2006-03-11 13:17:16
Subject: Re: How can I make multiple insertions ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group