PG重启异常处理

最新推荐文章于 2026-06-16 08:55:26 发布

原创最新推荐文章于 2026-06-16 08:55:26 发布 · 6.2k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

PostGreSql相关

这篇博客描述了PostgreSQL数据库在启动时遇到的异常情况，表现为数据库系统不断尝试启动但失败。日志显示系统未正常关闭，并在恢复过程中遇到输入/输出错误。解决方案是通过在bin目录下使用pg_resetxlog命令修复日志，然后重启数据库。

现象异常描述：

FATAL: the database system is starting up
LOG: database system shutdown was interrupted; last known up at 2021-08-14 11:37:30 CST
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at E2/960A61C8
FATAL: the database system is starting up
LOG: invalid record length at E2/98D4D680: wanted 24, got 0
LOG: redo done at E2/98D4D650
LOG: last completed transaction was at log time 2021-08-14 05:54:36.709512+08
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
PANIC: could not fsync file "base/168295/177386": Input/output error
LOG: startup process (PID 12293) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
LOG: database system is shut down

修复方法：

切换到bin目录下：
1
cd /usr/pgsql-9.3/bin
使用pg_resetxlog命令修复日志：（/var/lib/pgsql/9.3/data为pg_data的目录）
1
pg_resetxlog -f /var/lib/pgsql/9.3/data
重启数据库：
1
pg_ctl start