Re: psql: FATAL 1: IDENT authentication failed for user error

Поиск
Список
Период
Сортировка
От Devrim GUNDUZ
Тема Re: psql: FATAL 1: IDENT authentication failed for user error
Дата
Msg-id Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr
обсуждение исходный текст
Ответ на psql: FATAL 1: IDENT authentication failed for user error - Urgent pls  ("Kumar" <sgnerd@yahoo.com.sg>)
Список pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 19 Mar 2004, Kumar wrote:

> I have installed Linux Fedore and wanted to work with the default installed postgres 7.3.4 database.
> 
> I could able to create to create user, but while try to connect, I got the following error message
> psql: FATAL 1: IDENT authentication failed for user 
> 
> My pg_hba.conf file looks like below
> 
> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
> 
> local   all         all                                             trust
> host all     all  192.168.2.0   255.255.255.0     trust 

Are you sure that you've commented (or maybe deleted) the "ident" line? 
AFAIR, if there is a line about ident auth before the lines that you've 
pasted, PostgreSQL will take care of that line and will try ident auth.

Also, a reload is required after a change in pg_hba.conf.

Regards,
- -- 
Devrim GUNDUZ           
devrim@gunduz.org                devrim.gunduz@linux.org.tr         http://www.TDMSoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFAWwJPtl86P3SPfQ4RAnh4AKCPqY2Xu/ZBkuytA1puv2qtBN5AwQCglCuZ
7kouiIpk0hvxOOuAxhfPZnY=
=ktdd
-----END PGP SIGNATURE-----



В списке pgsql-sql по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: inverse of "day of year"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: inverse of "day of year"