Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0DD779FB895 for ; Mon, 2 Jul 2007 12:38:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 67975-08 for ; Mon, 2 Jul 2007 12:38:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CB2DA9FB87C for ; Mon, 2 Jul 2007 12:38:48 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l62FcbBo012192; Mon, 2 Jul 2007 11:38:37 -0400 (EDT) To: Ritu Khetan cc: pgsql-admin@postgresql.org Subject: Re: pg_hba.conf issue In-reply-to: References: Comments: In-reply-to Ritu Khetan message dated "Mon, 02 Jul 2007 18:40:22 +0530" Date: Mon, 02 Jul 2007 11:38:37 -0400 Message-ID: <12191.1183390717@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/9 X-Sequence-Number: 25990 Ritu Khetan writes: > # IPv4 local connections: > host all all 127.0.0.1/32 trust > # IPv6 local connections: > #host all all ::1/128 trust > #host all all 172.21.42.121/24 trust > host all all 172.21.51.56/24 trust > While this works at most of the locations, we have a peculiar error coming > up at 2-3 locations. The error reads: > no pg_hba.conf entry for host "::1" , user "crisil" , database "crisil" , > SSL off " No surprise: you have the IPv6 line commented out. Dunno why these particular boxes are preferring IPv6 to IPv4, maybe something different about the local DNS environment? Anyway, there is no point in refusing to serve ::1/128 if you're accepting 127.0.0.1. regards, tom lane