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

Re: authentication

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tim hall <tech(at)glastonburymusic(dot)org(dot)uk>
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: authentication
Date: 2004-08-24 03:11:49
Message-ID: 27345.1093317109@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
tim hall <tech(at)glastonburymusic(dot)org(dot)uk> writes:
> I'm fine with most things except I simply don't understand how authentication
> works - I have RTFM'd and still don't get it. I have no trouble connecting 
> with the Postmaster on my local machine via command-line psql, but I'm not 
> experiencing the same joy with Python or PgAccess, both return similar errors
> if I specify the Host as 'localhost':

> Python:
> _pg.error: FATAL:  IDENT authentication failed for user "tim"

IDENT works very differently for connections across TCP (which I suspect
is what Python/PgAccess are using) versus connections across a Unix
socket (which is what psql will use by default).  I suspect you are not
running an IDENT daemon, which is needed in the first case but not the
second.  But you should look in the postmaster log to find out more.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2004-08-24 06:58:16
Subject: Re: authentication
Previous:From: tim hallDate: 2004-08-24 02:15:09
Subject: authentication

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