Help with database recovery ...

From: Iztok Stotl <iztok(dot)stotl(at)guest(dot)arnes(dot)si>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with database recovery ...
Date: 2011-05-01 19:32:22
Message-ID: 1304278344.21857.2.camel@Hal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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
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
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:
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(at)pg_log]# postgres --version
postgres (PostgreSQL) 8.1.18

OS is Centos.

Any hint ?


Browse pgsql-general by date

  From Date Subject
Next Message Mark Morgan Lloyd 2011-05-01 20:42:38 Re: Postgresql, PSN hack and table limits
Previous Message Tom Lane 2011-05-01 16:41:46 Re: Values larger than 1/3 of a buffer page cannot be indexed (hstore)