PG重启异常处理

现象异常描述：

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