Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime - Mailing list pgsql-general

From Christoph Berg
Subject Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime
Date
Msg-id 20171112122658.md7u7ahq5raqezft@msg.df7cb.de
Whole thread Raw
In response to Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime  (Christoph Berg <myon@debian.org>)
Responses Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime
List pgsql-general
Re: To Adam Brusselback 2017-11-11 <20171111205316.u56lkmkakdmcx6zm@msg.df7cb.de>
> I'm investigating if it's a good idea to tell systemd to ignore the
> exit code of pg_ctl(cluster).

Telling systemd to ignore ExecStart errors seems to be the correct
solution. The service will still be active, with the startup error
being shown:

● postgresql@10-main.service - PostgreSQL Cluster 10-main  Loaded: loaded (/lib/systemd/system/postgresql@.service;
enabled;vendor preset: enabled)  Active: active (running) since Sun 2017-11-12 13:24:21 CET; 210ms ago Process: 31892
ExecStop=/usr/bin/pg_ctlcluster--skip-systemctl-redirect -m fast 10-main stop (code=exited, status=0/SUCCESS) Process:
31922ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 10-main start (code=exited, status=1/FAILURE)Main PID:
31928(postgres)   Tasks: 8 (limit: 4915)  CGroup: /system.slice/system-postgresql.slice/postgresql@10-main.service
   ├─31928 /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c
config_file=/etc/postgresql/10/main/postgresql.conf         ├─31931 postgres: 10/main: checkpointer process
├─31932postgres: 10/main: writer process          ├─31933 postgres: 10/main: wal writer process          ├─31934
postgres:10/main: autovacuum launcher process          ├─31935 postgres: 10/main: archiver process          ├─31936
postgres:10/main: stats collector process          └─31937 postgres: 10/main: bgworker: logical replication launcher
 

Nov 12 13:24:20 lehmann systemd[1]: Starting PostgreSQL Cluster 10-main...
Nov 12 13:24:21 lehmann postgresql@10-main[31922]: Error: /usr/lib/postgresql/10/bin/pg_ctl
/usr/lib/postgresql/10/bin/pg_ctlstart -D /var/lib/postgresql/10/main -l /var/log/postgresql/postgresql-10-main.log -t
0-s -o  -c config_file="/etc/postgresql/10/main/postgresql.conf"  exited with status 1:
 
Nov 12 13:24:21 lehmann postgresql@10-main[31922]: pg_ctl: server did not start in time
Nov 12 13:24:21 lehmann systemd[1]: postgresql@10-main.service: PID file /var/run/postgresql/10-main.pid not readable
(yet?)after start: No such file or directory
 
Nov 12 13:24:21 lehmann systemd[1]: Started PostgreSQL Cluster 10-main.

Fixed in
https://anonscm.debian.org/cgit/pkg-postgresql/postgresql-common.git/commit/?id=fc57e655c71e8f6bcb3010b054f5adbf32a224d7
,thanks for the report!
 

Christoph


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Lele Gaifax
Date:
Subject: Re: [GENERAL] Difference between CAST(v AS t) and v::t
Next
From: "Peter J. Holzer"
Date:
Subject: Re: [GENERAL] Postgres 10.1 fails to start: server did not start intime