最近做postgresql+drbd+heartbeat,在primary机突然断电后,slave机切换为primary正常,但数据库无法启动,错误如下:
frank@node1:~/cas/bin$ sudo /etc/init.d/postgresql start
* Starting PostgreSQL 9.3 database server
* The PostgreSQL server failed to start. Please check the log output:
2017-11-29 17:12:01 CST LOG: database system was interrupted; last known up at 2017-11-29 16:55:13 CST
2017-11-29 17:12:01 CST LOG: database system was not properly shut down; automatic recovery in progress
2017-11-29 17:12:01 CST LOG: record with zero length at 6/1C8E33B0
2017-11-29 17:12:01 CST LOG: redo is not required
2017-11-29 17:12:01 CST FATAL: could not access status of transaction 3805721
2017-11-29 17:12:01 CST DETAIL: Could not read from file "pg_clog/0003" at offset 163840: Success.
2017-11-29 17:12:01 CST LOG: startup process (PID 3452) exited with exit code 1
2017-11-29 17:12:01 CST LOG: aborti