Root@Test-Wal-Pitr-Test:/Path/To/Files/Pit-Recovery# sudo systemctl start postgresql@11-main.service Job for postgresql@11-main.service failed because the

Question

Root@Test-Wal-Pitr-Test:/Path/To/Files/Pit-Recovery# sudo systemctl start postgresql@11-main.service Job for postgresql@11-main.service failed because the

service did not take the steps required by its unit configuration.
See "systemctl status postgresql@11-main.service" and "journalctl -xe" for details.
root@test-wal-pitr-test:/path/to/files/pit-recovery# systemctl status postgresql@11-main.service
● postgresql@11-main.service - PostgreSQL Cluster 11-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: failed (Result: protocol) since Fri 2019-12-27 11:24:25 UTC; 4s ago
Process: 8474 ExecStart=/usr/bin/pg_ctlcluster --skip-systemctl-redirect 11-main start (code=exited, status=1/FAILURE)

Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: 2019-12-27 11:24:25.353 UTC [8484] FATAL: could not locate required checkpoint record
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: 2019-12-27 11:24:25.353 UTC [8484] HINT: If you are not restoring from a backup, try removing the file
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: 2019-12-27 11:24:25.355 UTC [8483] LOG: startup process (PID 8484) exited with exit code 1
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: 2019-12-27 11:24:25.355 UTC [8483] LOG: aborting startup due to startup process failure
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: 2019-12-27 11:24:25.371 UTC [8483] LOG: database system is shut down
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: pg_ctl: could not start server
Dec 27 11:24:25 test-wal-pitr-test postgresql@11-main[8474]: Examine the log output.
Dec 27 11:24:25 test-wal-pitr-test systemd[1]: postgresql@11-main.service: Can't open PID file /run/postgresql/11-main.pid (yet?) after start: No such file or direct
Dec 27 11:24:25 test-wal-pitr-test systemd[1]: postgresql@11-main.service: Failed with result 'protocol'.
Dec 27 11:24:25 test-wal-pitr-test systemd[1]: Failed to start PostgreSQL Cluster 11-main.

#backend #devops #pgsql #programming #russian

0

27.12.2019

1 ответов

17 просмотров

Grigory Smolkin · Accepted Answer

Grigory Smolkin

И все равно начало вы как-то умудрились потерять

0

27.12.2019

172 похожих чатов

Root@Test-Wal-Pitr-Test:/Path/To/Files/Pit-Recovery# sudo systemctl start postgresql@11-main.service Job for postgresql@11-main.service failed because the

1 ответов

Похожие вопросы