Re: Error with tcp/ip networking

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Error with tcp/ip networking
Дата
Msg-id 664.967700015@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Error with tcp/ip networking  ("Travis Bauer" <trbauer@cs.indiana.edu>)
Ответы Re: Error with tcp/ip networking  (Jules Bean <jules@jellybean.co.uk>)
Re: Error with tcp/ip networking  (Travis Bauer <trbauer@cs.indiana.edu>)
Список 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 по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: Large selects handled inefficiently?
Следующее
От: Val Trifonoff
Дата:
Сообщение: User_Permissions