首页 > 解决方案 > Postgres 服务器未启动

问题描述

您好,我无法启动我的 postgres 服务器。我的 pg_log 中出现此错误

2018-07-20 13:25:59 MUT LOG:  database system was interrupted; last known up at 2018-07-20 13:08:25 MUT
2018-07-20 13:27:27 MUT LOG:  database system was not properly shut down; automatic recovery in progress
2018-07-20 13:27:27 MUT LOG:  redo starts at 3/550D86E0
2018-07-20 13:27:29 MUT LOG:  record with zero length at 3/58B66398
2018-07-20 13:27:29 MUT LOG:  redo done at 3/58B66238
2018-07-20 13:27:29 MUT LOG:  last completed transaction was at log time 2018-07-20 13:12:09.874+04
2018-07-20 13:27:52 MUT LOG:  MultiXact member wraparound protections are now enabled
2018-07-20 13:27:53 MUT LOG:  database system is ready to accept connections
2018-07-20 13:27:53 MUT LOG:  autovacuum launcher started
2018-07-20 13:33:53 MUT LOG:  could not open file "postmaster.pid": No such file or directory
2018-07-20 13:33:53 MUT LOG:  performing immediate shutdown because data directory lock file is invalid
2018-07-20 13:33:53 MUT LOG:  received immediate shutdown request
2018-07-20 13:33:53 MUT WARNING:  terminating connection because of crash of another server process
2018-07-20 13:33:53 MUT 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.
2018-07-20 13:33:53 MUT HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2018-07-20 13:33:53 MUT WARNING:  terminating connection because of crash of another server process
2018-07-20 13:33:53 MUT 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.
2018-07-20 13:33:53 MUT HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2018-07-20 13:33:53 MUT WARNING:  terminating connection because of crash of another server process
2018-07-20 13:33:53 MUT 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.
2018-07-20 13:33:53 MUT HINT:  In a moment you should be able to reconnect to the database and repeat your command.

这出现在日志中。我在cmd中运行一个命令:

c:\Program Files\PostgreSQL\9.4\bin> .\pg_ctl.exe -D "C:\Program Files\PostgreSQL\9.4\data" start

server starting

并在 cmd 中出现此错误

c:\Program Files\PostgreSQL\9.4\bin>
2018-07-20 13:25:59 MUT LOG:  redirecting log output to logging collector process
2018-07-20 13:25:59 MUT HINT:  Future log output will appear in directory "pg_log".

在服务中也没有运行。

标签: postgresql-9.4

解决方案


推荐阅读