Re: URGENT : StreamServerPort: bind() failed: Cannotassign

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
andadvise 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?