My database crashed and server won't start ... ------------------------------------------------------ LOG: database system was interrupted while in recovery at 2011-05-01 19:31:37 CEST 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 2/D41C1350 LOG: redo record is at 2/D41C1350; undo record is at 0/0; shutdown FALSE LOG: next transaction ID: 752151177; next OID: 50716 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 2/D41C1394 PANIC: could not access status of transaction 752150401 DETAIL: could not read from file "pg_clog/02CD" at offset 73728: Success LOG: startup process (PID 3504) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down --------------------------------------------------------------- What can I do ? [root@pg_log]# postgres --version postgres (PostgreSQL) 8.1.18 OS is Centos. Any hint ? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
