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

Re: ident authentication

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au>
Subject: Re: ident authentication
Date: 2008-11-29 18:38:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Friday 21 November 2008 00:56:53 Shilpa Sudhakar wrote:
> Hi,
> I am trying to test different kinds of authentication in postgres.
> I'm to find a efficient way to link the OS user with the postgres user.
> This is to help for auditing purpose. This is similar to the query
> raised by another postgres user.
> As suggested by Tom to use ident, i tried setting up ident but it isn't
> working.
> In the hba.conf file, i add the below entry
> local     all     all      ident       sameuser

did you reload the file after modifying it? 

> The user logged in at OS level is "abc".  I created a user "abc" in
> postgres but when i do "psql -U abc -d dbname", i get the below error:
> FATAL: Ident authentication failed for user "abc"

What error do you get if you do "psql -d dbname" ? 

> Should i put an entry in pg_ident.conf file?
> Is using ident still the right way to go? Is LDAP a better option
> because when we login to the server, we login with our LDAP username and
> password.
> Thanks and Regards,
> Shilpa

Robert Treat

In response to

pgsql-admin by date

Next:From: Adam RadłowskiDate: 2008-11-30 05:34:42
Subject: max_fsm_relations
Previous:From: Tom LaneDate: 2008-11-28 19:37:16
Subject: Re: warm standby

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