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 843A9D1B16E for ; Fri, 4 Jun 2004 18:43:20 -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 49158-06 for ; Fri, 4 Jun 2004 21:43:18 +0000 (GMT) Received: from sj-iport-3.cisco.com (sj-iport-3-in.cisco.com [171.71.176.72]) by svr1.postgresql.org (Postfix) with ESMTP id 8018AD1B173 for ; Fri, 4 Jun 2004 18:43:13 -0300 (ADT) Received: from sj-core-2.cisco.com (171.71.177.254) by sj-iport-3.cisco.com with ESMTP; 04 Jun 2004 14:43:02 +0000 X-BrightmailFiltered: true Received: from sirathw2k01 (dhcp-171-69-99-44.cisco.com [171.69.99.44]) by sj-core-2.cisco.com (8.12.10/8.12.6) with ESMTP id i54LhDXl029744; Fri, 4 Jun 2004 14:43:13 -0700 (PDT) Reply-To: From: "Siddharth Rath (sirath)" To: "'Rob'" Cc: Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign Date: Fri, 4 Jun 2004 14:43:55 -0700 Message-ID: <002101c44a7d$0968b140$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 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 In-Reply-To: <40C0DD67.8090403@itsbeen.sent.com> Importance: Normal 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/48 X-Sequence-Number: 13708 Hi Rob, Please find the output of "strace -f /apps/systran/postgresql/bin/pg_ctl start -D /apps/systran/postgresql/data-linux > s.out 2> s.err" in the below provided URLs: http://us.f2.yahoofs.com/bc/40c0ea30_116c8/bc/My+Documents/s.err.err?bfd6OwABBgQwEsbt http://us.f2.yahoofs.com/bc/40c0ea30_116c8/bc/My+Documents/s.out.out?bfd6OwABCrTeXvUl I couldnot understand much of the s.err messages. It will be great if you please spare some time to go thru the same and advise me 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 1:37 PM To: sirath@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign Siddharth Rath (sirath) wrote: > Hi Rob, > I did run the script from > http://myclass.missouri.edu/~atb6x2/NETSERV/NS_serverpl.html and it > didn't give any error and the O/P of netstat -plunta | 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 - > tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 9481/perl > udp 0 0 0.0.0.0:54321 0.0.0.0:* - > > But I don't understand why I cant bind to the same port thru POSTGRES. > Please let me know what to do now to resolve this. > > Thanx and regards > Sidd OK, well given that that starts up (you ran it under the same user id that you are running pg with, right?), you should (kill that perl script) then try to start up pg under strace, that will give the clearest indication of what is going wrong. If you use : strace -f -e trace=network /usr/local/pgsql/bin... > s.out 2> s.err it might reduce the amount of output from strace but try : strace -f /usr/local/pgsql/bin... > s.out 2> s.err also. If you have a web site where you can post the files and then include the URL in your replies that might be better than trying cut & paste parts of the output to the mailing list if the output is long (the network one might be nice and short and contain the troublesome system calls and responses if you are lucky). ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings