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 95DB8D1B1DF for ; Fri, 4 Jun 2004 21:37:35 -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 06963-09 for ; Sat, 5 Jun 2004 00:37:33 +0000 (GMT) Received: from out2.smtp.messagingengine.com (out2.smtp.messagingengine.com [66.111.4.26]) by svr1.postgresql.org (Postfix) with ESMTP id C2EE3D1B188 for ; Fri, 4 Jun 2004 21:37:27 -0300 (ADT) X-Sasl-enc: 6ctU0OV/+/8+Aa+Fko2yIA 1086395848 Received: from [10.10.12.12] (unknown [198.144.200.210]) by www.fastmail.fm (Postfix) with ESMTP id DC697C045B3; Fri, 4 Jun 2004 20:37:26 -0400 (EDT) Message-ID: <40C1146D.5010705@itsbeen.sent.com> Date: Fri, 04 Jun 2004 17:31:41 -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 Cc: pgsql-admin@postgresql.org Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com> In-Reply-To: <002101c44a7d$0968b140$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-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/50 X-Sequence-Number: 13710 Siddharth Rath (sirath) wrote: > 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). Looks like it could be an IP address issues: bind(3, {sa_family=AF_INET, sin_port=htons(5432), sin_addr=inet_addr("64.102.22.156")}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address) write(2, "LOG: StreamServerPort: bind() f"..., 163) = 163 write(2, "/apps/systran/postgresql/bin/pos"..., 41) = 41 write(2, "cannot create INET stream port", 30) = 30 write(2, "\n", 1) = 1 unlink("/apps/systran/postgresql/data-linux/postmaster.pid") = 0 exit_group(1) = ? Process 9912 detached try just having the tcp socket run on 127.0.0.1 starters and see if you get the same msg... What does your ifconfig -a look like?