Re: postgres not starting

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>, Postgres General <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres not starting
Date: 2018-02-16 04:51:46
Message-ID: 1518756706.2909.4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Alan Hodgson wrote:
> 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.

This seems excessive - maybe the server he wants to start is already
running and there is no need to crash or wipe it.

To give a better answer we would have to know which operating system
it is, which PostgreSQL version and how it was installed.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2018-02-16 04:55:06 Re: postgres not starting
Previous Message Alan Hodgson 2018-02-16 00:54:20 Re: postgres not starting

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Torralba 2018-02-16 04:55:06 Re: postgres not starting
Previous Message Melvin Davidson 2018-02-16 04:26:41 Re: Database health check/auditing