Re: Problems with starting Postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with starting Postgres
Date
Msg-id 1428.976491350@sss.pgh.pa.us
Whole thread Raw
In response to Problems with starting Postgres  (Uro¹ Gruber <uros@sir-mag.com>)
List pgsql-general
Uro� Gruber <uros@sir-mag.com> writes:
> I started postgres with -i switch, but when i kill the proces i can't
> start it anymore on the same port. I tried this five times and i can
> start it now on 5 ports because i have to use everytime a new port.

> FATAL: StreamServerPort: bind() failed: Address already in use
>         Is another postmaster already running on that port?
>         If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> /usr/local/pgsql/bin/./postmaster: cannot create UNIX stream port

How are you killing the postmaster?

A plain kill (SIGTERM) should remove the socket file on its way out.
The only thing that wouldn't is kill -9 ... if you're doing it that
way, don't.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dominic J. Eidson"
Date:
Subject: Re: Problems with starting Postgres
Next
From: "Brett W. McCoy"
Date:
Subject: RE: Re: Re: Why PostgreSQL is not that popular as MySQL ?