Re: Postgres 10.1 fails to start: server did not start in time

Hey Christoph, I tried starting it with init (service postgresql
start), and pg_ctlcluster.

I modified the pg_ctl.conf and set the timeout higher so I could just
get my cluster back up and running properly, so I can't give you the
info on what systemctl status says at the moment.

On Sat, Nov 11, 2017 at 8:23 AM, Christoph Berg <myon(at)debian(dot)org> wrote:
> Re: Tom Lane 2017-11-10 <8027(dot)1510347112(at)sss(dot)pgh(dot)pa(dot)us>
>> > The recovery succeeds, but when I go to start the cluster on the
>> > standby, it begins to replay the WAL, and does so for about 30
>> > seconds. Then I get a line in my log saying:
>>
>> >> pg_ctl: server did not start in time
>
> Hi Adam,
>
> how did you start the server? Via pg_ctlcluster, the init system, or
> directly via pg_ctl?
>
>> > Followed by:
>> >> 2017-11-10 20:27:35.907 UTC [7132] LOG: received smart shutdown request
>> >> ERROR [063]: : terminated on signal [SIGTERM]
>>
>> ... pg_ctl itself wouldn't decide to forcibly shut down the server
>> if the timeout expired. It merely stops waiting and tells you so.
>> It seems like this must represent misdesign of whatever start script
>> you're using. I think you need to complain to the Debian packagers
>> about that.
>
> pg_ctlcluster doesn't shut down if startup fails, but to be sure, we'd
> need to see the full log of whatever initiated the startup. If you are
> using systemd, what does `systemctl status postgresql(at)10-main` report?
> If that doesn't have anything, also check journalctl.
>
> Christoph