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

Поиск
Список
Период
Сортировка
От Siddharth Rath (sirath)
Тема URGENT : StreamServerPort: bind() failed: Cannot assign requested address
Дата
Msg-id 09af01c449da$cb2e3dc0$2c6345ab@amer.cisco.com
обсуждение исходный текст
Ответы Re: URGENT : StreamServerPort: bind() failed: Cannot
Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address
Список 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
butdue 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)
startedcorrectly 
, but when I stopped the DB server with above mentioned command and started again it throws back the same old error. Is
thereanyway 
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
understandwhat 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: no ftp
Следующее
От: mike g
Дата:
Сообщение: Re: URGENT : StreamServerPort: bind() failed: Cannot