postgresql数据库开机无法启动，或者启动后立刻关闭，不知如何查找原因

youth_y

如题！

linuxdee

1.若是系统自带的PGSQL，请把/var/lib/pgsql/data/logfile的内容贴出来看看；
2.若是自己编译安装的PGSQL，请把/usr/local/pgsql/data/logfile内容贴出来看看。

[ 本帖最后由 linuxdee 于 2008-2-13 21:04 编辑 ]

youth_y

LOG:  database system was interrupted at 2008-02-08 11:30:08 EST
LOG:  checkpoint record is at 0/523BC0C
LOG:  redo record is at 0/523BC0C; undo record is at 0/0; shutdown FALSE
LOG:  next transaction id: 15285; next oid: 336464
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 0/523BC4C
LOG:  ReadRecord: record with zero length at 0/5242D3C
LOG:  redo done at 0/5242D18
LOG:  database system is ready
LOG:  database system was interrupted at 2008-02-08 11:46:46 EST
LOG:  checkpoint record is at 0/5257EB8
LOG:  redo record is at 0/5257EB8; undo record is at 0/0; shutdown FALSE
LOG:  next transaction id: 15597; next oid: 344656
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  ReadRecord: record with zero length at 0/5257EF8
LOG:  redo is not required
LOG:  database system is ready
LOG:  database system was interrupted at 2008-02-08 11:56:41 EST
LOG:  checkpoint record is at 0/5257EF8
LOG:  redo record is at 0/5257EF8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 15597; next oid: 344656
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  ReadRecord: record with zero length at 0/5257F38
LOG:  redo is not required
LOG:  database system is ready
LOG:  recycled transaction log file 0000000000000005
LOG:  recycled transaction log file 0000000000000006
LOG:  recycled transaction log file 0000000000000007
ERROR:  Attribute "br_name" not found
LOG:  recycled transaction log file 0000000000000008

youth_y

这不是当时的机器logfile,因为特殊原因那台机器已经被格了,就是不懂这些代码什么意思,谢谢指教!