pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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?



view thread (16+ messages)  latest in thread

Message-ID: <40C1146D.5010705@itsbeen.sent.com>
Permalink:  ../40C1146D.5010705@itsbeen.sent.com/
Also on:    postgresql.org/message-id/40C1146D.5010705@itsbeen.sent.com

 · 

reply

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