From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id F35911381F3 for ; Thu, 25 Apr 2013 07:11:07 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 6B7CAE09FC; Thu, 25 Apr 2013 07:10:59 +0000 (UTC) Received: from smtpq1.tb.mail.iss.as9143.net (smtpq1.tb.mail.iss.as9143.net [212.54.42.164]) by pigeon.gentoo.org (Postfix) with ESMTP id 15400E09EA for ; Thu, 25 Apr 2013 07:10:57 +0000 (UTC) Received: from [212.54.42.133] (helo=smtp2.tb.mail.iss.as9143.net) by smtpq1.tb.mail.iss.as9143.net with esmtp (Exim 4.71) (envelope-from ) id 1UVGKX-0002dM-Dh for gentoo-user@lists.gentoo.org; Thu, 25 Apr 2013 09:10:57 +0200 Received: from 54698b76.cm-12-2c.dynamic.ziggo.nl ([84.105.139.118] helo=data.antarean.org) by smtp2.tb.mail.iss.as9143.net with esmtp (Exim 4.71) (envelope-from ) id 1UVGKX-0000el-6R for gentoo-user@lists.gentoo.org; Thu, 25 Apr 2013 09:10:57 +0200 Received: from www.antarean.org (net.lan.antarean.org [10.20.13.13]) by data.antarean.org (Postfix) with ESMTP id 43A114B for ; Thu, 25 Apr 2013 09:10:35 +0200 (CEST) Received: from 10.55.16.19 (SquirrelMail authenticated user joost) by www.antarean.org with HTTP; Thu, 25 Apr 2013 09:10:35 +0200 Message-ID: In-Reply-To: <20130425054820.GB24932@syscon7.inet> References: <20130423123737.GB19375@syscon7.inet> <56cede771dcbb26af7fb96d215b6bca0.squirrel@www.antarean.org> <20130423154742.GC19375@syscon7.inet> <02354e00-f504-43d7-a22a-608aee8e7724@email.android.com> <20130423221621.GE19375@syscon7.inet> <20130424124011.GB6467@syscon7.inet> <22cd41f5-c643-4c58-8aa6-b8a0967bc3ad@email.android.com> <20130425002343.GD6467@syscon7.inet> <5178BC1D.40805@gmail.com> <20130425054820.GB24932@syscon7.inet> Date: Thu, 25 Apr 2013 09:10:35 +0200 Subject: Re: [gentoo-user] PosgreSQL - pg_hba.conf localhost access only From: "J. Roeleveld" To: gentoo-user@lists.gentoo.org User-Agent: SquirrelMail/1.4.22 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 (Normal) Importance: Normal Content-Transfer-Encoding: quoted-printable X-Ziggo-spambar: / X-Ziggo-spamscore: -0.9 X-Ziggo-spamreport: BAYES_00=-1.9,RDNS_DYNAMIC=0.982,RP_MATCHES_RCVD=-0.001 X-Ziggo-Spam-Status: No X-Spam-Status: No X-Spam-Flag: No X-Archives-Salt: 2f927a34-1408-4e19-afed-6c7abddcd374 X-Archives-Hash: 5ca47af9e31f099636f1c1b07972244e On Thu, April 25, 2013 07:48, Joseph wrote: > I just tried as you suggested, the only active line in: pg_hba.conf > local all all trust > > anything else is commented out. I restarted the server but I still can > connect to postgresql from another computer via Firefox. Joseph, Let me put it in really simple terms: 1) Firefox is NOT a database client, it can NOT connect to a database 2) Firefox IS a webbrowser, it ONLY connects to a webserver This means, Postgresql will NOT see ANY connection made by Firefox. The website you have running ON TOP OFF apache makes the connection to Postgresql. Eg. it goes like the following: User <-> Firefox <-> Apache/website <-> Postgresql Any of the above can ONLY see their immediate neighbour. -- Joost