On May 25 11:04, Richard Huxton wrote:
> surabhi.ahuja wrote:
> >hi,
> >i am getting the following error messages:
> >
> ><2006-05-24 15:28:08 CDT%>LOG: could not bind IPv4 socket: Address
> >already in use
> ><2006-05-24 15:28:08 CDT%>HINT: Is another postmaster already running on
> >port 5432? If not, wait a few seconds and retry.
> ><2006-05-24 15:28:08 CDT%>WARNING: could not create listen socket for
> >"localhost"
> ><2006-05-24 15:28:08 CDT%>LOG: database system was shut down at
> >2006-05-24 15:28:08 CDT
>
> This is what it says. You've either got:
> 1. another version of PostgreSQL running on port 5432
> 2. Something else on port 5432
> 3. The operating-system hasn't recycled the port after a shutdown (it
> can take a few seconds sometimes).
Just for curiosity, shouldn't SO_REUSEADDR (in
backend/libpq/pqcomm.c:342) handle the 3rd possibility in the above
list? Or isn't this behaviour guaranteed by SO_REUSEADDR on every
platform?
Regards.