Re: URGENT : StreamServerPort: bind() failed: Cannotassign

Rob said:
> 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.