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 5FCF3D1B451 for ; Fri, 4 Jun 2004 13:12:42 -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 93087-01 for ; Fri, 4 Jun 2004 16:12:40 +0000 (GMT) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id DBCF7D1B435 for ; Fri, 4 Jun 2004 13:12:38 -0300 (ADT) Received: from sj-core-4.cisco.com (171.68.223.138) by sj-iport-5.cisco.com with ESMTP; 04 Jun 2004 09:12:54 -0700 X-BrightmailFiltered: true Received: from sirathw2k01 (sjc-vpn4-874.cisco.com [10.21.83.105]) by sj-core-4.cisco.com (8.12.10/8.12.6) with ESMTP id i54GCZZR016366; Fri, 4 Jun 2004 09:12:35 -0700 (PDT) Reply-To: From: "Siddharth Rath (sirath)" To: "'Rob'" , Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign Date: Fri, 4 Jun 2004 09:13:17 -0700 Message-ID: <001a01c44a4e$d945eec0$15b8a943@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 In-Reply-To: <40C04504.3070708@itsbeen.sent.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/39 X-Sequence-Number: 13699 Hi Rob, Thanx for the response. The O/P of netstat -na | grep 5432 is : 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:* Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe this should be created). Details of /tmp is given below: />ls -ls | grep tmp 0 drwxrwxrwt 2 root root 140 Jun 3 23:14 tmp /tmp >ls -al total 64 drwxrwxrwt 2 root root 140 Jun 3 23:14 . drwxr-xr-x 21 root root 4096 Jun 3 12:20 .. -rw-r--r-- 1 root root 2037 Jun 3 12:21 bootinfo -rwxr-xr-x 1 root root 578 Jun 3 23:14 find_perl5 -rw-r--r-- 1 root root 43732 Jun 3 23:14 mk_accounts_client -rw-r--r-- 1 root root 1828 Jun 3 12:21 prtdiag-osaka.2004:06:03:12:21:22 -rw-r--r-- 1 root root 23 Jun 3 23:14 sendme.osaka Please let me know how to proceed from here. Thanx and regards Sidd -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rob Sent: Friday, June 04, 2004 2:47 AM To: sirath@cisco.com; pgsql-admin@postgresql.org Subject: Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign Siddharth Rath (sirath) wrote: >> >>The O/P of >netstat -plunt | grep 5432 >> what about just : netstat -na | grep 5432 to see if any 5432 stuff is hanging around and if so in what state... It may be that you are missing the evidence of the problem because you filtered -plut (process id, listening, udp, tcp) but the error msg talks about a StreamServerPort bind problem but those unix domain lines won't be displayed with that set of filters and so it may be some weirdness with stream and/or lock files in your /tmp directory? Just a guess. Rob ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)