Re: Problems with starting Postgres

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