Help with database recovery ...
От | Iztok Stotl |
---|---|
Тема | Help with database recovery ... |
Дата | |
Msg-id | 1304278344.21857.2.camel@Hal обсуждение исходный текст |
Ответы |
Re: Help with database recovery ...
|
Список | pgsql-general |
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 ?
В списке pgsql-general по дате отправления: