Thread: StreamServerPort: bind() failed

Hi,

after killing a running postmaster I wanted to restart it with
  postmaster -i -d 1 -B 2048 -D /data_dir
but it gave the following error message:

FindBackend: searching PATH ...
FindBackend: found "/coot1/postgres/bin/postgres" using PATH
FATAL: StreamServerPort: bind() failed: errno=125
        Is another postmaster already running on that port?
        If not, wait a few seconds and retry.
postmaster: cannot create INET stream port

For sure, there is no other postmaster running. So, I had a coffee, that needed
longer than 'a few seconds' and retried. Same error message. Without '-i' it
works fine. It also works after rebooting the machine. But, who wants to reboot
every time you want to start postmaster ;-)

The system I'm working on is IRIX64 and the used postgresql is version 6.3.2 (
I know, there is 6.4, but I couldn't upgrade yet).

I saw the same question in the archives, but there was no answer :-(

Any help?

Thanks,
Joerg

--
Internet Joerg.Schultz@embl-heidelberg.de
Address  EMBL, Meyerhofstr 1, 69012 Heidelberg, Germany
Tel      +49 (0)6221 387 534, Fax +49 (0)6221 387517
URL      http://www.embl-heidelberg.de/~jschultz/

Joerg.Schultz@EMBL-Heidelberg.de said:
> after killing a running postmaster I wanted to restart it with
>   postmaster -i -d 1 -B 2048 -D /data_dir but it gave the following
> error message:

On Linux postmaster creates the file /tmp/.s.PGSQL.5432, a named pipe (???)
  that it uses for IPC I believe.  The 5432 is whatever port you have
  postgres listening on.
Anyway, I remove that file if it exists before starting postmaster, an that
  takes care of the message you pasted.
I also kill any running "postgres" processes, since they cause postmaster to
  hang as well sometimes.
--

                          Yes is a BARGAIN
                          No is a TURNOFF  - Wire
--Zachariah - Studio Archetype - 415-659-4435 - mailto:zack@studioarchetype.com