Re: URGENT : StreamServerPort: bind() failed: Cannotassign - Mailing list pgsql-admin

From Rob
Subject Re: URGENT : StreamServerPort: bind() failed: Cannotassign
Date
Msg-id 40C04504.3070708@itsbeen.sent.com
Whole thread Raw
In response to Re: URGENT : StreamServerPort: bind() failed: Cannotassign requested address  ("Siddharth Rath (sirath)" <sirath@cisco.com>)
Responses Re: URGENT : StreamServerPort: bind() failed: Cannotassign
List pgsql-admin
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




pgsql-admin by date:

Previous
From: "Siddharth Rath (sirath)"
Date:
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address
Next
From: "Goulet, Dick"
Date:
Subject: Re: Knowing postgres processes..