centos - 无法重新启动 Postgres 服务器，也无法终止进程

Question

由于 PostGreSQL 9.3 数据库服务器 (CentOS) 突然断电，我尝试启动/停止/重启 postgres 服务器时出现此错误:

[root@aca80123 ~]# service postgresql-9.3 restart 

    Restarting PostgreSQL 9.3: 
    pg_ctl: PID file "/opt/PostgreSQL/9.3/data/postmaster.pid" does not exist
    Is server running?
    starting server anyway
    waiting for server to start........ stopped waiting
    pg_ctl: could not start server
    Examine the log output.
    PostgreSQL 9.3 did not start in a timely fashion, please see /opt/PostgreSQL/9.3/data/pg_log/startup.log for details

以下消息在 startup.log 文件中

2016-03-01 23:24:18 IST LOG:  redirecting log output to logging collector process
2016-03-01 23:24:18 IST HINT:  Future log output will appear in directory "pg_log".

我找到了 stackOverflow 问题，但没有解决方案。 postgresql-service-unable-to-stop-start-restart unable-to-restart-postgresql-server

Answer 1

如果PID文件不存在，尝试检查所有正在使用postgresql数据库的空闲 session 。

ps -ef|grep postgres

使用 postgresql 终止所有 session 。查看数据库状态

pg_ctl status
pg_ctl: no server running

启动服务器后:

pg_ctl start
server starting
**postgres@server_name:~$ 2016-03-02 11:44:10 IST    LOG:  redirecting log output to logging collector process
2016-03-02 11:44:10 IST    HINT:  Future log output will appear in directory "pg_log".

检查状态

pg_ctl status

pg_ctl: server is running (PID: 51615)
/opt/postgres/9.3/bin/postgres