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.102As 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 md5host all all 0.0.0.0/0
md5# IPv6 local connections:#host all all ::1/128
md5I'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.1Wireless 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.1Tunnelanslutning: 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.
http://get.live.com/betas
