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 1A2F5D1B1DC for ; Fri, 4 Jun 2004 03:10:22 -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 30809-05 for ; Fri, 4 Jun 2004 06:10:22 +0000 (GMT) Received: from sj-iport-1.cisco.com (sj-iport-1-in.cisco.com [171.71.176.70]) by svr1.postgresql.org (Postfix) with ESMTP id 25C4ED1B1A1 for ; Fri, 4 Jun 2004 03:10:20 -0300 (ADT) Received: from sj-core-5.cisco.com (171.71.177.238) by sj-iport-1.cisco.com with ESMTP; 03 Jun 2004 23:10:34 -0700 X-BrightmailFiltered: true Received: from sirathw2k01 (sjc-vpn2-364.cisco.com [10.21.113.108]) by sj-core-5.cisco.com (8.12.10/8.12.6) with ESMTP id i546AIls013105 for ; Thu, 3 Jun 2004 23:10:19 -0700 (PDT) Reply-To: From: "Siddharth Rath (sirath)" To: Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address Date: Thu, 3 Jun 2004 23:11:00 -0700 Message-ID: <09be01c449fa$b5a493d0$2c6345ab@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.5709 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 In-Reply-To: <20256.1086321893@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/32 X-Sequence-Number: 13692 Hi Tom, Thanx for the reply and suggestion. Actually , I did wait for more than 5 hrs before posting this issue in this alias. It will be really great if you can advise on how to proceed from here. Does the below information points to any issue with my Linux Box configuration is it an issue with POSTGRES: 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 Thanx in advance. Regards Sidd -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, June 03, 2004 9:05 PM To: sirath@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannot assign requested address "Siddharth Rath (sirath)" writes: > When I tried to restart the DB/Postmaster it says : > StreamServerPort: bind() failed: Cannot assign requested address > Is another postmaster already running on port 5432? > If not, wait a few seconds and retry. > cannot create INET stream port Did you try waiting a while, as suggested by the error message? Many TCP stacks have a timeout before they will let a pre-existing port number be reassigned. (This is to prevent any risk of packets for old connections getting delivered to the new owner of the port.) regards, tom lane