Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"
От | Andy Shellam |
---|---|
Тема | Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres" |
Дата | |
Msg-id | !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABqE1/441HpSbsDD9z3ZGpWAQAAAAA=@mailnetwork.co.uk обсуждение исходный текст |
Ответ на | Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres" (ow <oneway_111@yahoo.com>) |
Ответы |
Re: pg_hba.conf + all + trust = Ident authentication failed for user "postgres"
|
Список | 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of ow Sent: Monday, 06 March, 2006 1:21 PM To: pgsql-admin@postgresql.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.shellam@mailnetwork.co.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@postgresql.org so that your message can get through to the mailing list cleanly !DSPAM:14,440c377449413902250303!
В списке pgsql-admin по дате отправления: