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 2BABE1381F3 for ; Wed, 24 Apr 2013 05:12:15 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id CE332E0AAD; Wed, 24 Apr 2013 05:12:06 +0000 (UTC) Received: from smtpq2.gn.mail.iss.as9143.net (smtpq2.gn.mail.iss.as9143.net [212.54.34.165]) by pigeon.gentoo.org (Postfix) with ESMTP id 90B1EE0A9B for ; Wed, 24 Apr 2013 05:12:05 +0000 (UTC) Received: from [212.54.34.135] (helo=smtp4.gn.mail.iss.as9143.net) by smtpq2.gn.mail.iss.as9143.net with esmtp (Exim 4.71) (envelope-from ) id 1UUrzx-0003fk-0k for gentoo-user@lists.gentoo.org; Wed, 24 Apr 2013 07:12:05 +0200 Received: from 54698b76.cm-12-2c.dynamic.ziggo.nl ([84.105.139.118] helo=data.antarean.org) by smtp4.gn.mail.iss.as9143.net with esmtp (Exim 4.71) (envelope-from ) id 1UUrzw-0001YH-PM for gentoo-user@lists.gentoo.org; Wed, 24 Apr 2013 07:12:05 +0200 Received: from www.antarean.org (net.lan.antarean.org [10.20.13.13]) by data.antarean.org (Postfix) with ESMTP id 275D44B for ; Wed, 24 Apr 2013 07:11:44 +0200 (CEST) Received: from 212.159.196.71 (SquirrelMail authenticated user joost) by www.antarean.org with HTTP; Wed, 24 Apr 2013 07:11:44 +0200 Message-ID: In-Reply-To: <20130423221621.GE19375@syscon7.inet> References: <20130423001731.GB5934@syscon7.inet> <81bef797b52ca11c567d3e5a93c9d7e4.squirrel@www.antarean.org> <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> Date: Wed, 24 Apr 2013 07:11:44 +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: 8458b49a-4c30-472b-8c5e-c5865cf4f680 X-Archives-Hash: 2dc3fd918e77c1975309b414536d901c On Wed, April 24, 2013 00:16, Joseph wrote: > On 04/23/13 20:10, J. Roeleveld wrote: >>I am guessing Apache is running on the same machine as your Postgresql >> server? >> >>In this case. The connection will always originate from localhost and >> Postgresql is behaving as it should. >> >>You will need to secure access to the website to avoid people accessing >> it. >> > > Yes, every machine I run has apache on it, so Postgresql server runs o= n > it as well. > If I'm connecting from another network machine to a server, how does it > originate from localhost? > > Something is not correct. I'll try to explain. When you connect to the website (Apache) the connection Apache sees originates from your machine. When Apache then needs to access PostgreSQL to access the data needed for the website, Postgresql sees the connection originating from Apache, whic= h is running on the same machine. -- Joost