Re: [gentoo-user] PosgreSQL - pg_hba.conf localhost access only

[Joseph <syscon780@gmail.com>]

On 04/23/13 20:10, J. Roeleveld wrote:

[snip]
>>I'm using SQL-Ledger (firefox) to access the postgresql.
>>Brief history:
>>I had a problem in the past when I upgraded to posgresql-9.1, all of a
>>sudden I could not access the sql-ledger.
>>
>>The solution was to add "postgres group" to apache user.
>>The reason for it was the change in directory permission:
>>
>>postgresql 8.x
>>drwxrwx--x 2 postgres postgres 4096 Dec 14 19:57 /var/run/postgresql/
>>
>>postgresql 9.x
>>drwxrwx--- 2 postgres postgres 4096 Dec 19 13:21 /var/run/postgresql/
>>
>>So:
>>groups apache
>>apache postgres
>>
>>groups postgres
>>postgres
>>
>>I hope this is correct as adding group "apache" to postgres user does
>>not work.
>>
>>But I just realized that any user from local network can access my
>>sql-ledger using browser.
>>--
>>Joseph
>
>Joseph.
>
>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.
>
>Kind regards
>
>Joost Roeleveld

Yes, every machine I run has apache on it, so  Postgresql server runs on it as well.
If I'm connecting from another network machine to a server, how does it originate from localhost?

Something is not correct.

-- 
Joseph