From: Rob <pgadmin@itsbeen.sent.com>
To: sirath@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
Date: Fri, 04 Jun 2004 17:31:41 -0700
Message-ID: <40C1146D.5010705@itsbeen.sent.com> (raw)
In-Reply-To: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com>
References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com>
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pgadmin@itsbeen.sent.com, sirath@cisco.com
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
In-Reply-To: <40C1146D.5010705@itsbeen.sent.com>
References: <002101c44a7d$0968b140$2c6345ab@amer.cisco.com> <40C1146D.5010705@itsbeen.sent.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox