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 14B89D1B1A1 for ; Fri, 4 Jun 2004 06:51:49 -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 05075-02 for ; Fri, 4 Jun 2004 09:51:50 +0000 (GMT) Received: from out2.smtp.messagingengine.com (out2.smtp.messagingengine.com [66.111.4.26]) by svr1.postgresql.org (Postfix) with ESMTP id 1170DD1B17A for ; Fri, 4 Jun 2004 06:51:47 -0300 (ADT) X-Sasl-enc: DluAIzpblc8VxOGZmxX6PA 1086342708 Received: from [10.10.12.12] (unknown [198.144.200.210]) by www.fastmail.fm (Postfix) with ESMTP id 2C65BC04440; Fri, 4 Jun 2004 05:51:46 -0400 (EDT) Message-ID: <40C04504.3070708@itsbeen.sent.com> Date: Fri, 04 Jun 2004 02:46:44 -0700 From: Rob User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: sirath@cisco.com, pgsql-admin@postgresql.org Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign References: <09bb01c449f9$f44b0ca0$2c6345ab@amer.cisco.com> In-Reply-To: <09bb01c449f9$f44b0ca0$2c6345ab@amer.cisco.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/33 X-Sequence-Number: 13693 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