Postgres不写日志

Question

重新启动PostgreSQL之后，日志文件已经停止写入。

只会出现以下日志。

FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 1351) running in data directory "/var/lib/pipelinedb/9.5"?
FATAL:  lock file "postmaster.pid" already exists
HINT:  Is another postmaster (PID 1351) running in data directory "/var/lib/pipelinedb/9.5"?
LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "log".
LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "log".
LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "log".

Answer 1

您似乎已经有一个服务器实例正在运行。尝试连接到psql，或者使用ps aux | grep -i postgres来检查它。如果另一个服务器实例正在运行，请不要使用kill -9，因为您可能损坏数据。相反，请做：

pg_ctl -D /var/lib/pipelinedb/9.5 stop -m fast

在此之后，您应该正确地启动服务器。