Allowing LAN connections - Mailing list pgsql-general
From | Jonas Gauffin |
---|---|
Subject | Allowing LAN connections |
Date | |
Msg-id | BAY138-W3862298C428707B656765DA2E00@phx.gbl Whole thread Raw |
Responses |
Re: Allowing LAN connections
Re: Allowing LAN connections |
List | pgsql-general |
I've installed postgresql 8.2 on a windows vista machine and are trying to connect to it from another one.
the server has ip 192.168.1.100 and the client 192.168.1.102
As I understand it, I should make some configuration changes in pg_hba.conf to make this happen.
Both machines has both ipv4 and ipv6 installed (Vista standard I guess).
Ive tried some different settings in the pg_hba.conf (trying one at a time, commenting out the rest):
# IPv4 local connections:
#host all all 127.0.0.1/32 md5
#host all all 192.168.0.0/16 md5
host all all 0.0.0.0/0 md5
# IPv6 local connections:
#host all all ::1/128 md5
I've also changed listten_addresses in postgresql.conf to:
listen_addresses = '*'
-----------------------------
I've installed VmWare player on the server. I guess that it's why it have so many adapters:
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::7dba:9969:999b:5bfe%11
IPv4 Address. . . . . . . . . . . : 192.168.1.100
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1
Wireless LAN adapter Wireless Network Connection:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Ethernet adapter Local Area Connection 2:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::440f:5179:acc9:5799%14
IPv4 Address. . . . . . . . . . . : 192.168.243.1
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
Ethernet adapter Local Area Connection 3:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::d48:1d79:2215:543a%16
IPv4 Address. . . . . . . . . . . : 192.168.11.1
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
Tunnel adapter Local Area Connection* 6:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter Local Area Connection* 7:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::5efe:192.168.1.100%12
Default Gateway . . . . . . . . . :
Tunnel adapter Local Area Connection* 10:
Media State . . . . . . . . . . . : Media disconnected
Connection-specific DNS Suffix . :
Tunnel adapter Local Area Connection* 11:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::5efe:192.168.243.1%15
Default Gateway . . . . . . . . . :
Tunnel adapter Local Area Connection* 12:
Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::5efe:192.168.11.1%17
Default Gateway . . . . . . . . . :
------------------
And the client:
Ethernet-anslutning Anslutning till lokalt nätverk:
Anslutningsspecifika DNS-suffix . :
IPv4-adress . . . . . . . . . . . : 192.168.1.102
Nätmask . . . . . . . . . . . . . : 255.255.255.0
Standard-gateway. . . . . . . . . : 192.168.1.1
Tunnelanslutning: Anslutning till lokalt nätverk*:
Tillstånd . . . . . . . . . . . . : Frånkopplad
Anslutningsspecifika DNS-suffix . :
Tunnelanslutning: Anslutning till lokalt nätverk* 2:
Anslutningsspecifika DNS-suffix . :
Länklokal IPv6-adress . . . . . . : fe80::5efe:192.168.1.102%10
Standard-gateway. . . . . . . . . :
(sorry for the swedish ;)
----------------------
Any suggestions?
Ta en titt på de nya onlinetjänsterna på Windows Live Betas -- så nya att de ännu inte har lanserats officiellt. Prova på!
pgsql-general by date: