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!
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" |