From: Erwan Arzur <erwan@free.fr>
To: Rob <pgadmin@itsbeen.sent.com>
Cc: sirath@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
Date: Tue, 08 Jun 2004 14:36:21 +0200
Message-ID: <40C5B2C5.9010805@free.fr> (raw)
In-Reply-To: <40C1146D.5010705@itsbeen.sent.com>
References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com>
<40C1146D.5010705@itsbeen.sent.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: erwan@free.fr, pgadmin@itsbeen.sent.com, sirath@cisco.com
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
In-Reply-To: <40C5B2C5.9010805@free.fr>
References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com> <40C1146D.5010705@itsbeen.sent.com> <40C5B2C5.9010805@free.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox