Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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 ?


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group