Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address - Mailing list pgsql-admin

From Tom Lane
Subject Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address
Date
Msg-id 20256.1086321893@sss.pgh.pa.us
Whole thread Raw
In response to URGENT : StreamServerPort: bind() failed: Cannot assign requested address  ("Siddharth Rath (sirath)" <sirath@cisco.com>)
Responses Re: URGENT : StreamServerPort: bind() failed: Cannot assign requested address
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot
Next
From: Tom Lane
Date:
Subject: Re: URGENT : StreamServerPort: bind() failed: Cannot