X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 443CBD1B4BC for ; Fri, 19 Mar 2004 15:12:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38143-05 for ; Fri, 19 Mar 2004 11:12:13 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5CFC0D1EBD0 for ; Fri, 19 Mar 2004 11:12:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2JFCBis024214; Fri, 19 Mar 2004 10:12:11 -0500 (EST) To: Martin Marques Cc: "Kumar" , "psql" Subject: Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls In-reply-to: <200403191005.40561.martin@bugs.unl.edu.ar> References: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> <200403191005.40561.martin@bugs.unl.edu.ar> Comments: In-reply-to Martin Marques message dated "Fri, 19 Mar 2004 10:05:40 -0300" Date: Fri, 19 Mar 2004 10:12:11 -0500 Message-ID: <24213.1079709131@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/205 X-Sequence-Number: 17304 Martin Marques 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