Re: To Adam Brusselback 2017-11-11
<20171111205316.u56lkmkakdmcx...@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: 31922 ExecStart=/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
├─31932 postgres: 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_ctl start -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
