Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0D320633029 for ; Mon, 29 Mar 2010 03:44:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 19125-01 for ; Mon, 29 Mar 2010 06:44:24 +0000 (UTC) X-Greylist: delayed 00:05:42.471308 by SQLgrey-1.7.6 Received: from smtp.domeneshop.no (smtp.domeneshop.no [194.63.248.54]) by mail.postgresql.org (Postfix) with ESMTP id 22CB963271B for ; Mon, 29 Mar 2010 03:44:27 -0300 (ADT) Received: from [194.237.103.50] (helo=charliex.local) by smtp.domeneshop.no with esmtpa (Exim 4.71) (envelope-from ) id 1Nw8cU-0007tY-49; Mon, 29 Mar 2010 08:38:42 +0200 Message-ID: <4BB04AF1.1030001@blogg.se> Date: Mon, 29 Mar 2010 08:38:41 +0200 From: =?UTF-8?B?Um9iZXJ0IEdyYXZzasO2?= Reply-To: robert@blogg.se Organization: Blogg Esse AB User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; sv-SE; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4 MIME-Version: 1.0 To: Nilesh Govindarajan CC: pgsql-admin@postgresql.org Subject: Re: Socket & TCP connections References: <4BAF8DA9.2010000@itech7.com> <4BB00A9C.2040007@itech7.com> In-Reply-To: <4BB00A9C.2040007@itech7.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.762 tagged_above=-10 required=5 tests=AWL=0.837, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/257 X-Sequence-Number: 34056 Nilesh Govindarajan skrev 2010-03-29 04.04: > Hi, it seems to be working now. Can somebody explain to me how ? See > this pg_hba.conf - Did you reload the config, i.e pg_ctl reload, after making changes the first time? Regards, roppert > > # "local" is for Unix domain socket connections only > local all root trust > local all all md5 > # IPv4 local connections: > #host all root 127.0.0.1/32 trust > #host all root ::1/128 trust > host all all 127.0.0.1/32 md5 > host all all ::1/128 md5 > > Its the same code I think which I wrote previously. But now it asks > password when connected through TCP and doesn't when connected directly > as psql -d postgres > > PLZ EXPLAIN !! I'm in a big confusion :? >