From: Siddharth Rath (sirath) <sirath@cisco.com>
To: 'Rob' <pgadmin@itsbeen.sent.com>
To: pgsql-admin@postgresql.org
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
Date: Fri, 4 Jun 2004 09:13:17 -0700
Message-ID: <001a01c44a4e$d945eec0$15b8a943@amer.cisco.com> (raw)
In-Reply-To: <40C04504.3070708@itsbeen.sent.com>
Hi Rob,
Thanx for the response.
The O/P of netstat -na | grep 5432 is :
tcp 0 0 0.0.0.0:54320 0.0.0.0:* LISTEN
udp 0 0 0.0.0.0:54321 0.0.0.0:*
Surprisingly .s.PGSQL.5432 file is not getting created in /tmp directory ( I believe this should be created).
Details of /tmp is given below:
/>ls -ls | grep tmp
0 drwxrwxrwt 2 root root 140 Jun 3 23:14 tmp
/tmp >ls -al
total 64
drwxrwxrwt 2 root root 140 Jun 3 23:14 .
drwxr-xr-x 21 root root 4096 Jun 3 12:20 ..
-rw-r--r-- 1 root root 2037 Jun 3 12:21 bootinfo
-rwxr-xr-x 1 root root 578 Jun 3 23:14 find_perl5
-rw-r--r-- 1 root root 43732 Jun 3 23:14 mk_accounts_client
-rw-r--r-- 1 root root 1828 Jun 3 12:21 prtdiag-osaka.2004:06:03:12:21:22
-rw-r--r-- 1 root root 23 Jun 3 23:14 sendme.osaka
Please let me know 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 2:47 AM
To: sirath@cisco.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] URGENT : StreamServerPort: bind() failed: Cannotassign
Siddharth Rath (sirath) wrote:
>>
>>The O/P of >netstat -plunt | grep 5432
>>
what about just :
netstat -na | grep 5432
to see if any 5432 stuff is hanging around and if so in
what state...
It may be that you are missing the evidence of the problem because you
filtered -plut (process id, listening, udp, tcp) but the error msg talks
about a StreamServerPort bind problem but those unix domain lines won't
be displayed with that set of filters and so it may be some weirdness
with stream and/or lock files in your /tmp directory? Just a guess.
Rob
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
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: sirath@cisco.com, pgadmin@itsbeen.sent.com
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannotassign
In-Reply-To: <001a01c44a4e$d945eec0$15b8a943@amer.cisco.com>
References: <40C04504.3070708@itsbeen.sent.com> <001a01c44a4e$d945eec0$15b8a943@amer.cisco.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