Thread: IDENT auth. problem

IDENT auth. problem

From
"Graham Vickrage"
Date:
Hi All,

I am experiencing strange behaviour with psql. I normally log with
authentication type: ident sameuser

I have just exited from a psql session where I dropped a table and then
immediately logged back in and now I am getting: -

IDENT authentication failed for user 'postgres'

I have checked all the usual; ph_hba.conf, pg_shadow, restarting postmaster
with -i and environment variable PGHOST=localhost.

Does anyone have any ideas, similar probs or a way of tracing at what point
its failing.

Thanks in advance,

Graham.

PG Ver.  7.1.2
SuSE Linux 6.3



Re: IDENT auth. problem

From
Tom Lane
Date:
"Graham Vickrage" <graham@digitalplanit.com> writes:
> I have just exited from a psql session where I dropped a table and then
> immediately logged back in and now I am getting: -

> IDENT authentication failed for user 'postgres'

> I have checked all the usual; ph_hba.conf, pg_shadow, restarting postmaster
> with -i and environment variable PGHOST=localhost.

Did you look in the postmaster log?  There should be a more-detailed
message there.

A first guess, though, is that your identd daemon stopped running.

            regards, tom lane