Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"

From: "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk>
To: "'ow'" <oneway_111(at)yahoo(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"
Date: 2006-03-06 13:27:29
Message-ID: !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABqE1/441HpSbsDD9z3ZGpWAQAAAAA=@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

No you're right, there shouldn't be anything in pg_ident.conf.

Check in your postgresql.conf file, and set "listen_interfaces" to *, so it
listens on TCP/IP (if not already.)

Then try connecting with "psql -U postgres -h localhost" and see if that
lets you on. Also check your postgresql.conf file is not forcing pgSQL to
look elsewhere for your config files.

Andy

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of ow
Sent: Monday, 06 March, 2006 1:21 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] pg_hba.conf + all + trust = Ident authentication failed
for user "postgres"

No, pg_ident.conf is empty (i.e. contains only comments). My impression was
that with "trust" nothing was needed in pg_ident.conf, no?

Thanks

--- Andy Shellam <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk> wrote:

> Does your pg_ident.conf contain anything with reference to testusr? As it
> seems to be trying Ident authentication over everything else and failing.
>
> Andy
>

---------------------------------------------------------------------------

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

!DSPAM:14,440c377449413902250303!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ow 2006-03-06 13:59:01 Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"
Previous Message ow 2006-03-06 13:21:15 Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"