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 |
Thread: | |
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
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(at)pg_log]# postgres --version
postgres (PostgreSQL) 8.1.18
OS is Centos.
Any hint ?
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) |