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.83.72.128.86.1142105181.squirrel@83.72.128.86 (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

Im about to make a small webapplication using Postgresql.

My system is Debian 3.1 Sarge with Postgresql 8.1 from backports.org.

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
permissions:
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    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"


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.

Regards
Ronni


Responses

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-2014 The PostgreSQL Global Development Group