X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CC49F475DFD for ; Thu, 13 Feb 2003 00:24:47 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id D5586475E30 for ; Thu, 13 Feb 2003 00:22:41 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1D5MV5u010693; Thu, 13 Feb 2003 00:22:31 -0500 (EST) To: Wei Weng Cc: pgsql-sql@postgresql.org Subject: Re: What's wrong with this identification configuration? In-reply-to: <200302111626.01386.wweng@cs.columbia.edu> References: <200302111626.01386.wweng@cs.columbia.edu> Comments: In-reply-to Wei Weng message dated "Tue, 11 Feb 2003 16:26:01 -0500" Date: Thu, 13 Feb 2003 00:22:30 -0500 Message-ID: <10692.1045113750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/275 X-Sequence-Number: 11673 Wei Weng writes: > This is the idenfication setup in my /var/lib/pgsql/data/pg_hba.conf > local all trust > host all 127.0.0.1 255.255.255.255 trust > This is supposed to authenticate any user to be able to access my postgresql > system any time, no? Any local user, yes. > But this is what happened: > [root@Monet wweng]# su postgres > bash-2.05a$ psql template1 > psql: FATAL 1: No pg_hba.conf entry for host localhost, user postgres, > database template1 Did you recently change the pg_hba.conf file? If so, maybe you forgot to SIGHUP the postmaster to get it to re-read the file. Otherwise, my only thought is that you aren't talking to the same postmaster you thought you were ... that pg_hba.conf should definitely let in any local connection ... regards, tom lane