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 6720FD1B2BD for ; Fri, 4 Jun 2004 03:04:58 -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 25273-09 for ; Fri, 4 Jun 2004 06:04:58 +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 47853D1B256 for ; Fri, 4 Jun 2004 03:04:56 -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:05:10 -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 i5464sls010134 for ; Thu, 3 Jun 2004 23:04:54 -0700 (PDT) Reply-To: From: "Siddharth Rath (sirath)" To: Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign requested address Date: Thu, 3 Jun 2004 23:05:36 -0700 Message-ID: <09bb01c449f9$f44b0ca0$2c6345ab@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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: <1086321373.21104.11.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/31 X-Sequence-Number: 13691 Hi Mike, Thanx for the response. The ps -A don't have POSTMASTER and I did check it = earlier too. Do you foresee any issue with Linux configuration or is it the POSTGRES issue? Please let me know how to procee= d from here.=20 Thanx in advance. Regards Sidd -----Original Message----- From: mike g [mailto:mike@thegodshalls.com]=20 Sent: Thursday, June 03, 2004 8:56 PM To: sirath@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign= requested address Hi, I believe a fast shutdown prevents new connections to the db, sends termina= tion signals to any applications with current connections, and then after it receives confirmation that those application= s have aborted their transactions and closed their connections the db stops. It sounds like your application is either not responding to or confirming t= he shutdown request from the db. The details in that archive were trying to explain how to find which proces= s / application are still connected to the db after the fast shutdown attempted to terminate them. Without root access though maybe you aren't able to see which process is st= ill attached to the db? Try doing a ps -A and see if the postmaster is still showing up in the proc= ess list. If it is then you know for sure that the db is not truly shutdown. On Thu, 2004-06-03 at 21:22, Siddharth Rath (sirath) wrote: > Hi, > I've an application running on RedHat Linux and we are using Postgres=20 > as our DB. Initially the DB was running perfectly but due to some=20 > requirement we stopped the DB with " pg_ctl stop -m 'fast' " command.=20 > When I tried to restart the DB/Postmaster it says : >=20 > 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 >=20 > Since I don't have root access , I took the help of the Sysadmin to=20 > reboot the system and the DB server(POSTGRES) started correctly , but=20 > when I stopped the DB server with above mentioned command and started=20 > again it throws back the same old error. Is there anyway to get rid of=20 > these. >=20 > I found some details in archieves at=20 > http://list.linux-vserver.org/archive/vserver/msg04095.html . But I=20 > don't understand what to do next. >=20 > The O/P of >netstat -plunt | grep 5432 >=20 > (Not all processes could be identified, non-owned process info will=20 > 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:* LISTE= N -=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 >=20 > And O/P of netstat -ranv >=20 > 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 >=20 > Any pointers/help in resolving this issue will be highly appreciated. >=20 > Thanx and regards > Sidd >=20 >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly