一次停电不正常关机导致Postgresql服务无法启动的解决

最新推荐文章于 2025-11-22 12:41:56 发布

原创最新推荐文章于 2025-11-22 12:41:56 发布 · 2.5k 阅读

1 ·

CC 4.0 BY-SA版权

postgreSQL 语言设计专栏收录该内容

33 篇文章

订阅专栏

无法启动时,应该看一下logfile发生了什么事: vi /home/postgres/logfile, 一般突然断电关机会留下pid文件未删除导致出现pre-existing shared memory block这个错误, 删除postmaster.pid即可.

[root@DGNEWDEV system]# ll /live/db/data/postmaster.pid
-rw------- 1 postgres postgres 77 Feb 13 11:48 /live/db/data/postmaster.pid
[root@DGNEWDEV system]# rm /live/db/data/postmaster.pid
rm: remove regular file ‘/live/db/data/postmaster.pid’? y
[root@DGNEWDEV system]# service postgres start
Starting postgres:
postgres started. Its log is kept as /home/postgres/logfile.
[root@DGNEWDEV system]# service postgres status
pg_ctl: server is running (PID: 1904)
/usr/pgsql-9.4/bin/postgres "-i" "-D" "/live/db/data"
[root@DGNEWDEV system]#