Re: postgres not starting

From: Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: 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:55:06
Message-ID: CACut7uRZRfz=KRXZzdmZtKA4bfgcK2LgvSVhWYmBddcd7nhrpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

The poster writes ....

" I think the error caused because I removed everything under /data
directory before stopping the server. "

If you did remove the data directory, you will need to kill any processes
hanging on then initdb -D /your/data/directory

Without a data directory it will not start.

On Thu, Feb 15, 2018 at 8:51 PM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> 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
>
>

--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and
delete the copy you received. Thank You.

In response to

Browse pgsql-admin by date

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

Browse pgsql-general by date

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