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

["J. Roeleveld" <joost@antarean.org>]

On Tue, April 23, 2013 14:37, Joseph wrote:
> On 04/23/13 10:07, J. Roeleveld wrote:
>>On Tue, April 23, 2013 02:17, Joseph wrote:
>>> In my "pg_hba.conf" I have:
>>>
>>> local	all             all             		        trust
>>> host    all             all             127.0.0.1/32            trust
>>>
>>> I was under impression that this is configuration is for localhost
>>> "127.0.0.1" access only.
>>> But to my surprise I can access my database from other machine on my
>>> network and even from another sub-network that I'm connected to via VPN
>>>
>>> How this authentication/access work?
>>
>>Normally that should be sufficient.
>>On which machine does the client-software run?
>>
>>--
>>Joost Roeleveld
>
> postgresql server runs on my machine but all other machines on the network
> including the one on remote location that I'm connected to via VPN can
> connect to postgresql
> database.
> I don't want other machine to have access to my server database.
>
> Even with a single line in pg_hba.conf
>  local   all   all   trust
>
> all other machine on the network can connect to my postgresql database.

If the PostgreSQL database is running on machine X.
And you are using machine Y.

What command do you type to connect on machine Y?

--
Joost