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 2B38AD1B260 for ; Thu, 3 Jun 2004 23:21:51 -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 59975-10 for ; Fri, 4 Jun 2004 02:21:54 +0000 (GMT) Received: from sj-iport-2.cisco.com (sj-iport-2-in.cisco.com [171.71.176.71]) by svr1.postgresql.org (Postfix) with ESMTP id E43B0D1B273 for ; Thu, 3 Jun 2004 23:21:48 -0300 (ADT) Received: from sj-core-5.cisco.com (171.71.177.238) by sj-iport-2.cisco.com with ESMTP; 03 Jun 2004 19:20:28 -0700 Received: from sirathw2k01 (dhcp-171-69-99-44.cisco.com [171.69.99.44]) by sj-core-5.cisco.com (8.12.10/8.12.6) with ESMTP id i542Lols017752 for ; Thu, 3 Jun 2004 19:21:51 -0700 (PDT) Reply-To: From: "Siddharth Rath (sirath)" To: Subject: URGENT : StreamServerPort: bind() failed: Cannot assign requested address Date: Thu, 3 Jun 2004 19:22:32 -0700 Message-ID: <09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 1 (Highest) X-MSMail-Priority: High X-Mailer: Microsoft Outlook, Build 10.0.5709 Importance: High X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/27 X-Sequence-Number: 13687 Hi, I've an application running on RedHat Linux and we are using Postgres as ou= r DB. Initially the DB was running perfectly but due to some requirement we stopped the DB with " pg_ctl stop -m 'fast' " command. = 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 Since I don't have root access , I took the help of the Sysadmin to reboot = the system and the DB server(POSTGRES) started correctly , but when I stopped the DB server with above mentioned command and started= again it throws back the same old error. Is there anyway to get rid of these. I found some details in archieves at http://list.linux-vserver.org/archive/= vserver/msg04095.html . But I don't understand what to do next. 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 = -=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 udp 0 0 0.0.0.0:54321 0.0.0.0:* = -=20=20=20=20=20=20=20=20=20 And O/P of netstat -ranv Kernel IP routing table Destination Gateway Genmask Flags MSS Window irtt If= ace 10.83.103.0 0.0.0.0 255.255.255.192 U 0 0 0 et= h2 64.102.29.0 0.0.0.0 255.255.255.0 U 0 0 0 et= h0 169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 et= h2 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 et= h0 Any pointers/help in resolving this issue will be highly appreciated. Thanx and regards Sidd