pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql: FATAL 1: IDENT authentication failed for user error - Urgent pls
4+ messages / 4 participants
[nested] [flat]
* psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
@ 2004-03-19 12:39 Kumar <sgnerd@yahoo.com.sg>
0 siblings, 2 replies; 4+ messages in thread
From: Kumar @ 2004-03-19 12:39 UTC (permalink / raw)
To: pgsql-sql
Dear Friends,
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
I couldnt understand why. Please shed some light
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
@ 2004-03-19 13:05 Martin Marques <martin@bugs.unl.edu.ar>
parent: Kumar <sgnerd@yahoo.com.sg>
1 sibling, 1 reply; 4+ messages in thread
From: Martin Marques @ 2004-03-19 13:05 UTC (permalink / raw)
To: Kumar <sgnerd@yahoo.com.sg>; pgsql-sql
El Vie 19 Mar 2004 09:39, Kumar escribió:
> Dear Friends,
>
> 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
>
> I couldnt understand why. Please shed some light
This is not the default configuration, so I suspect that you changed it. Try
to reload PostgreSQL and try again.
--
10:04:02 up 10 days, 14:35, 4 users, load average: 0.27, 0.24, 0.27
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: psql: FATAL 1: IDENT authentication failed for user error
@ 2004-03-19 14:23 Devrim GUNDUZ <devrim@gunduz.org>
parent: Kumar <sgnerd@yahoo.com.sg>
1 sibling, 0 replies; 4+ messages in thread
From: Devrim GUNDUZ @ 2004-03-19 14:23 UTC (permalink / raw)
To: Kumar <sgnerd@yahoo.com.sg>; +Cc: 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-----
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
@ 2004-03-19 15:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Martin Marques <martin@bugs.unl.edu.ar>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-03-19 15:12 UTC (permalink / raw)
To: Martin Marques <martin@bugs.unl.edu.ar>; +Cc: Kumar <sgnerd@yahoo.com.sg>; pgsql-sql
Martin Marques <martin@bugs.unl.edu.ar> writes:
> El Vie 19 Mar 2004 09:39, Kumar escribió:
>> 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
>>
>> I couldnt understand why. Please shed some light
> This is not the default configuration, so I suspect that you changed it.
... and forgot to SIGHUP the postmaster after changing it, so the
original IDENT-based selection is still active. Do "pg_ctl reload"
to get the postmaster to notice changes in its config files.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-03-19 15:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-19 12:39 psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Kumar <sgnerd@yahoo.com.sg>
2004-03-19 13:05 ` Martin Marques <martin@bugs.unl.edu.ar>
2004-03-19 15:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-03-19 14:23 ` Re: psql: FATAL 1: IDENT authentication failed for user error Devrim GUNDUZ <devrim@gunduz.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox