X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED019D1B3B6 for ; Tue, 8 Jun 2004 09:36:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25732-04 for ; Tue, 8 Jun 2004 12:36:24 +0000 (GMT) Received: from ioskeha.hittite.isp.9tel.net (ioskeha.hittite.isp.9tel.net [62.62.156.27]) by svr1.postgresql.org (Postfix) with ESMTP id B787FD1B188 for ; Tue, 8 Jun 2004 09:36:17 -0300 (ADT) Received: from [10.0.0.100] (146.106-30-212.9massy1-1-ro-as-i2-2.9tel.net [212.30.106.146]) by ioskeha.hittite.isp.9tel.net (Postfix) with ESMTP id CA6F117B848; Tue, 8 Jun 2004 14:37:23 +0200 (CEST) Message-ID: <40C5B2C5.9010805@free.fr> Date: Tue, 08 Jun 2004 14:36:21 +0200 From: Erwan Arzur User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rob Cc: sirath@cisco.com, pgsql-admin@postgresql.org Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com> <40C1146D.5010705@itsbeen.sent.com> In-Reply-To: <40C1146D.5010705@itsbeen.sent.com> X-Enigmail-Version: 0.83.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/88 X-Sequence-Number: 13748 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.