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 Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin