| From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Kumar <sgnerd(at)yahoo(dot)com(dot)sg> |
| Cc: | psql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: psql: FATAL 1: IDENT authentication failed for user error |
| Date: | 2004-03-19 14:23:10 |
| Message-ID: | Pine.LNX.4.44.0403191618280.4719-100000@emo.org.tr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-19 15:10:05 | Re: inverse of "day of year" |
| Previous Message | Robert Creager | 2004-03-19 13:47:14 | Re: inverse of "day of year" |