Hi!
We use postgreSQL 8.1.2 in
Solaris 9 platform to maintain very important business data. The
postgresql DB was interrupted now:
> more
postgresql-2007-03-05_210154.log
LOG: could not bind socket for
statistics collector: Cannot assign requested address
LOG: database system was
interrupted while in recovery at 2007-03-05 20:26:30 CST
HINT: This probably means that
some data is corrupted and you will have to use the last backup for
recovery.
LOG: checkpoint record is at
114/FDB86500
LOG: redo record is at
114/FDB2B0F8; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID:
8817742; next OID: 106734149
LOG: next MultiXactId: 60550;
next MultiXactOffset: 14674685
LOG: database system was not
properly shut down; automatic recovery in progress
LOG: redo starts at
114/FDB2B0F8
LOG: record with zero length
at 115/249891E8
LOG: redo done at
115/249891B8
PANIC: failed to re-find
parent key in "1560660"
LOG: startup process (PID
14266) was terminated by signal 6
LOG: aborting startup due to
startup process failure
LOG: logger shutting
down
