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

"Siddharth Rath (sirath)" <sirath@cisco.com> writes:
> 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

Did you try waiting a while, as suggested by the error message?  Many
TCP stacks have a timeout before they will let a pre-existing port
number be reassigned.  (This is to prevent any risk of packets for old
connections getting delivered to the new owner of the port.)

            regards, tom lane