bind(3, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("64.102.22.156")}, 16) = -1 EADDRNOTAVAIL (Cannot
Looks like you're trying to tell postgres to listen on an IP address your computer is not configured for :
Siddharth said:
The O/P of >netstat -plunt | grep 5432
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:54320 0.0.0.0:* LISTEN - udp 0 0 0.0.0.0:54321 0.0.0.0:* - And O/P of netstat -ranv
Kernel IP routing table
Destination Gateway Genmask Flags MSS Window irtt Iface
10.83.103.0 0.0.0.0 255.255.255.192 U 0 0 0 eth2
64.102.29.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth2
127.0.0.0 0.0.0.0 255.0.0.0 U 0 0 0 lo
0.0.0.0 64.102.29.1 0.0.0.0 UG 0 0 0 eth0
There's no network matching 64.102.22.156 in your routing table ...
Check your configuration file.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster