Re: To Adam Brusselback 2017-11-11 <20171111205316.u56lkmkakdmcx6zm@xxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
