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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rob Sent: Friday, June 04, 2004 1:37 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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?
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
