Re: Error with tcp/ip networking - Mailing list pgsql-general

From Tom Lane
Subject Re: Error with tcp/ip networking
Date
Msg-id 664.967700015@sss.pgh.pa.us
Whole thread Raw
In response to Error with tcp/ip networking  ("Travis Bauer" <trbauer@cs.indiana.edu>)
Responses Re: Error with tcp/ip networking  (Jules Bean <jules@jellybean.co.uk>)
Re: Error with tcp/ip networking  (Travis Bauer <trbauer@cs.indiana.edu>)
List pgsql-general
"Travis Bauer" <trbauer@cs.indiana.edu> writes:
> I'm getting:
> FATAL: StreamServerPort: bind() failed: Address already in use
>         Is another postmaster already running on that port?
>         If not, wait a few seconds and retry.

> when I use postmaster with the -i option.  Yes, I already deleted the
> /tmp/?????.5432 files.  When I run postmaster without -i, it works fine, but
> no tcp/ip access.

Well, the /tmp files are for non-TCP (Unix socket) communication, so
they're not relevant to this failure.  The postmaster is complaining
because it can't get ownership of the 5432 TCP port number.  I'm betting
that you have another postmaster process still hanging around, or else
(much less likely, but possible) some unrelated program that happens to
have grabbed onto the 5432 TCP port number.

Try using 'netstat' to see if 5432 is in use...

            regards, tom lane

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Large selects handled inefficiently?
Next
From: Val Trifonoff
Date:
Subject: User_Permissions