Re: postgres not starting

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres not starting
Date: 2018-02-16 00:54:20
Message-ID: 1518742460.11219.15.camel@lists.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Thu, 2018-02-15 at 18:21 -0600, Azimuddin Mohammed wrote:
> Hello,
> I am unable to start postgres on one of the server
> I am getting below error "HINT: is another postmaster already running
> on port 5432, if not wait a few seconds and retry"
> I checked the processes nothing is running with postgres
>
> I think the error caused because I removed everything under /data
> directory before stopping the server.
> Can someone help.
>
>

kill -9 the old processes. The old postmaster is holding onto the port.
And probably some of the old file handles, too, so you might want to
re-init the new database cluster after really cleaning up the old one.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-02-16 04:51:46 Re: postgres not starting
Previous Message geoff hoffman 2018-02-16 00:32:20 Re: postgres not starting

Browse pgsql-general by date

  From Date Subject
Next Message Tim Cross 2018-02-16 02:22:28 Database health check/auditing
Previous Message geoff hoffman 2018-02-16 00:32:20 Re: postgres not starting