Help with database recovery ... - Mailing list pgsql-general

From Iztok Stotl
Subject Help with database recovery ...
Date
Msg-id 1304278344.21857.2.camel@Hal
Whole thread Raw
Responses Re: Help with database recovery ...  (Craig Ringer <craig@postnewspapers.com.au>)
List 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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Next
From: Scott Marlowe
Date:
Subject: Re: pervasiveness of surrogate (also called synthetic) keys