Re: Debugging Failed Startup - Mailing list pgsql-general

From Ray Cote
Subject Re: Debugging Failed Startup
Date
Msg-id CAG5tnzqE5oN8Fh+Ni9YwDZc6fMv7nxZ++FAYD-w1w=Bsyu3uHw@mail.gmail.com
Whole thread Raw
In response to Re: Debugging Failed Startup  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general


On Thu, May 2, 2019 at 4:12 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
On 2019-May-02, Ray Cote wrote:

> Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 is
> not starting on CentOS 7?
> Was running fine for several weeks then fails to come up after a reboot.

How are you getting it started after the reboot?  If you're not using
systemd facilities (eg. if you're calling pg_ctl on your own script),
systemd may be getting confused about what's the status of the service
and stopping it on its own.
systemctl start postgresql-11
Plus I've run systemctl enable postgresql-11

 
Also, what are the timestamp differences between the final "redirecting
log output" line and the "Failed to start" lines?
0 second difference. 

Not sure what's happend. Re-installed a second time. Now it has survived pass three reboots and seems happy. Was just odd that there wasn't any error message as to why it failed.

As an aside to the person asking about changing back the hostname. 
I re-installed using the new hostname and it still failed once. 

Thanks for everyone's feedback. 
Seems to be happy again.
--Ray
 


--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Raymond Cote, President
voice: +1.603.924.6079 email: rgacote@AppropriateSolutions.com skype: ray.cote


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Debugging Failed Startup
Next
From: Guntry Vinod
Date:
Subject: RE: Back Slash \ issue