URGENT : StreamServerPort: bind() failed: Cannot assign requested address

From: "Siddharth Rath (sirath)" <sirath(at)cisco(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: URGENT : StreamServerPort: bind() failed: Cannot assign requested address
Date: 2004-06-04 02:22:32
Message-ID: 09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I've an application running on RedHat Linux and we are using Postgres as our DB. Initially the DB was running perfectly but due to
some requirement we stopped the DB with " pg_ctl stop -m 'fast' " command. When I tried to restart the DB/Postmaster it says :

StreamServerPort: bind() failed: Cannot assign requested address
Is another postmaster already running on port 5432?
If not, wait a few seconds and retry.
cannot create INET stream port

Since I don't have root access , I took the help of the Sysadmin to reboot the system and the DB server(POSTGRES) started correctly
, but when I stopped the DB server with above mentioned command and started again it throws back the same old error. Is there anyway
to get rid of these.

I found some details in archieves at http://list.linux-vserver.org/archive/vserver/msg04095.html . But I don't understand what to do
next.

The O/P of >netstat -plunt | 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 -
udp 0 0 0.0.0.0:54321 0.0.0.0:* -

And O/P of netstat -ranv

Kernel IP routing table
Destination Gateway Genmask Flags MSS Window irtt Iface
10.83.103.0 0.0.0.0 255.255.255.192 U 0 0 0 eth2
64.102.29.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth2
127.0.0.0 0.0.0.0 255.0.0.0 U 0 0 0 lo
0.0.0.0 64.102.29.1 0.0.0.0 UG 0 0 0 eth0

Any pointers/help in resolving this issue will be highly appreciated.

Thanx and regards
Sidd

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mike g 2004-06-04 03:56:14 Re: URGENT : StreamServerPort: bind() failed: Cannot
Previous Message Robert Treat 2004-06-03 18:01:39 Re: no ftp