1 |
On Tue, April 23, 2013 14:37, Joseph wrote: |
2 |
> On 04/23/13 10:07, J. Roeleveld wrote: |
3 |
>>On Tue, April 23, 2013 02:17, Joseph wrote: |
4 |
>>> In my "pg_hba.conf" I have: |
5 |
>>> |
6 |
>>> local all all trust |
7 |
>>> host all all 127.0.0.1/32 trust |
8 |
>>> |
9 |
>>> I was under impression that this is configuration is for localhost |
10 |
>>> "127.0.0.1" access only. |
11 |
>>> But to my surprise I can access my database from other machine on my |
12 |
>>> network and even from another sub-network that I'm connected to via VPN |
13 |
>>> |
14 |
>>> How this authentication/access work? |
15 |
>> |
16 |
>>Normally that should be sufficient. |
17 |
>>On which machine does the client-software run? |
18 |
>> |
19 |
>>-- |
20 |
>>Joost Roeleveld |
21 |
> |
22 |
> postgresql server runs on my machine but all other machines on the network |
23 |
> including the one on remote location that I'm connected to via VPN can |
24 |
> connect to postgresql |
25 |
> database. |
26 |
> I don't want other machine to have access to my server database. |
27 |
> |
28 |
> Even with a single line in pg_hba.conf |
29 |
> local all all trust |
30 |
> |
31 |
> all other machine on the network can connect to my postgresql database. |
32 |
|
33 |
If the PostgreSQL database is running on machine X. |
34 |
And you are using machine Y. |
35 |
|
36 |
What command do you type to connect on machine Y? |
37 |
|
38 |
-- |
39 |
Joost |