Re: Permissions to users ??? (FATAL: Ident authentication

From: "Ronni" <rofe(at)mailme(dot)dk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Permissions to users ??? (FATAL: Ident authentication
Date: 2006-03-11 22:56:53
Message-ID: 3352.83.72.128.86.1142117813.squirrel@83.72.128.86
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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.
>

The bottom of my pg_hba.conf look like this:
------------------------------------------------------------------------------------
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database
# super user can access the database using some other method.
# Noninteractive
# access to all databases is required during automatic maintenance
# (autovacuum, daily cronjob, replication, and similar tasks).
#
# Database administrative login by UNIX sockets
local all postgres ident sameuser

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host wt wt_admin 127.0.0.1/32 md5
host wt wt_public 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Reject all other connection attempts
host all all 0.0.0.0 0.0.0.0 reject
------------------------------------------------------------------------------------

And as you can see I put it under #IPv4 local connections:

I've tried to make a new user called web, grant all privileges on a table
in database wt, and added web like wt_admin above, with the same result, I
dont get to log in.

I made the users with createuser, and answered no to every question. My
own user, which I created the same way, but answered yes to every question
have no problems at all.

Regards
Ronni

> "Ronni" <rofe(at)mailme(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message 王宝兵 2006-03-12 07:34:24 About Buffer Flushing Function
Previous Message Tom Lane 2006-03-11 22:03:34 Re: Permissions to users ??? (FATAL: Ident authentication failed for user)