Добрый день!
Что-то пошло не так... После перезагрузки сервера не запускается служба postgres.
2017-03-29 18:31:23 MSK FATAL: the database system is starting up
2017-03-29 18:31:23 MSK LOG: database system was interrupted; last known up at 2017-03-29 16:56:45 MSK
2017-03-29 18:31:24 MSK FATAL: the database system is starting up
2017-03-29 18:31:25 MSK FATAL: the database system is starting up
2017-03-29 18:31:26 MSK FATAL: the database system is starting up
2017-03-29 18:31:27 MSK FATAL: the database system is starting up
2017-03-29 18:31:28 MSK FATAL: the database system is starting up
2017-03-29 18:31:29 MSK FATAL: the database system is starting up
2017-03-29 18:31:30 MSK FATAL: the database system is starting up
2017-03-29 18:31:31 MSK FATAL: the database system is starting up
2017-03-29 18:31:32 MSK FATAL: the database system is starting up
2017-03-29 18:31:33 MSK FATAL: the database system is starting up
2017-03-29 18:31:34 MSK FATAL: the database system is starting up
2017-03-29 18:31:35 MSK FATAL: the database system is starting up
2017-03-29 18:31:36 MSK FATAL: the database system is starting up
2017-03-29 18:31:37 MSK FATAL: the database system is starting up
2017-03-29 18:31:38 MSK FATAL: the database system is starting up
2017-03-29 18:31:39 MSK FATAL: the database system is starting up
2017-03-29 18:31:40 MSK FATAL: the database system is starting up
2017-03-29 18:31:41 MSK FATAL: the database system is starting up
2017-03-29 18:31:42 MSK FATAL: the database system is starting up
2017-03-29 18:31:43 MSK FATAL: the database system is starting up
2017-03-29 18:31:44 MSK FATAL: the database system is starting up
2017-03-29 18:31:45 MSK FATAL: the database system is starting up
2017-03-29 18:31:46 MSK FATAL: the database system is starting up
2017-03-29 18:31:47 MSK FATAL: the database system is starting up
2017-03-29 18:31:48 MSK FATAL: the database system is starting up
2017-03-29 18:31:49 MSK FATAL: the database system is starting up
2017-03-29 18:31:50 MSK FATAL: the database system is starting up
2017-03-29 18:31:51 MSK FATAL: the database system is starting up
2017-03-29 18:31:52 MSK FATAL: the database system is starting up
2017-03-29 18:31:53 MSK FATAL: the database system is starting up
2017-03-29 18:31:54 MSK FATAL: the database system is starting up
2017-03-29 18:31:55 MSK FATAL: the database system is starting up
2017-03-29 18:31:56 MSK FATAL: the database system is starting up
2017-03-29 18:31:57 MSK FATAL: the database system is starting up
2017-03-29 18:31:59 MSK FATAL: the database system is starting up
2017-03-29 18:32:00 MSK FATAL: the database system is starting up
2017-03-29 18:32:01 MSK FATAL: the database system is starting up
2017-03-29 18:32:02 MSK FATAL: the database system is starting up
2017-03-29 18:32:03 MSK FATAL: the database system is starting up
2017-03-29 18:32:04 MSK FATAL: the database system is starting up
2017-03-29 18:32:05 MSK FATAL: the database system is starting up
2017-03-29 18:32:06 MSK FATAL: the database system is starting up
2017-03-29 18:32:07 MSK FATAL: the database system is starting up
2017-03-29 18:32:08 MSK FATAL: the database system is starting up
2017-03-29 18:32:09 MSK FATAL: the database system is starting up
2017-03-29 18:32:10 MSK FATAL: the database system is starting up
2017-03-29 18:32:11 MSK FATAL: the database system is starting up
2017-03-29 18:32:12 MSK FATAL: the database system is starting up
2017-03-29 18:32:13 MSK FATAL: the database system is starting up
2017-03-29 18:32:14 MSK FATAL: the database system is starting up
2017-03-29 18:32:15 MSK FATAL: the database system is starting up
2017-03-29 18:32:16 MSK FATAL: the database system is starting up
2017-03-29 18:32:17 MSK FATAL: the database system is starting up
2017-03-29 18:32:18 MSK FATAL: the database system is starting up
2017-03-29 18:32:19 MSK FATAL: the database system is starting up
2017-03-29 18:32:20 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:32:52 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:33:59 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:35:05 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:36:11 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:16 MSK FATAL: the database system is starting up
2017-03-29 18:37:18 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:22 MSK FATAL: the database system is starting up
2017-03-29 18:38:25 MSK FATAL: the database system is starting up
> что-то пошло не
> что-то пошло не так.
посмотрите ещё логи где-то
В том-то и дело, что ничего
В том-то и дело, что ничего больше нет.
ОС пишет:
2017-03-29 20:11:33 MSK LOG: redirecting log output to logging collector process
2017-03-29 20:11:33 MSK HINT: Future log output will appear in directory "pg_log".
Timed out waiting for server startup
После команды: pg_resetxlog
После команды: pg_resetxlog -f
Логи такие:
2017-03-29 20:49:36 MSK LOG: database system was shut down at 2017-03-29 20:49:29 MSK
2017-03-29 20:49:36 MSK LOG: database system is ready to accept connections
2017-03-29 20:49:58 MSK PANIC: could not open critical system index 2671
2017-03-29 20:49:58 MSK PANIC: could not open critical system index 2671
2017-03-29 20:49:58 MSK PANIC: could not open critical system index 2671
2017-03-29 20:49:58 MSK PANIC: could not open critical system index 2671
2017-03-29 20:49:58 MSK LOG: server process (PID 3764) exited with exit code 3
2017-03-29 20:49:58 MSK LOG: terminating any other active server processes
2017-03-29 20:49:58 MSK PANIC: could not open critical system index 2671
2017-03-29 20:49:58 MSK WARNING: terminating connection because of crash of another server process
2017-03-29 20:49:58 MSK DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-03-29 20:49:58 MSK HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-03-29 20:49:58 MSK WARNING: terminating connection because of crash of another server process
2017-03-29 20:49:58 MSK DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-03-29 20:49:58 MSK HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-03-29 20:49:58 MSK WARNING: terminating connection because of crash of another server process
2017-03-29 20:49:58 MSK DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2017-03-29 20:49:58 MSK HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-03-29 20:49:58 MSK LOG: all server processes terminated; reinitializing
2017-03-29 20:50:09 MSK FATAL: pre-existing shared memory block is still in use
2017-03-29 20:50:09 MSK HINT: Check if there are any old server processes still running, and terminate them.
После команды: pg_resetxlog
А потом повторение первых логов, пока опять не сделаешь эту команду...
Собсно... Если кто
Собсно...
Если кто столкнется: пришлось все-таки откатывать виртуалку на день назад и после pg_resetxlog -f служба поднялась. Спасибо. Топик можно закрывать.