9.1.2 Postgres corruption, any way to recover? - Mailing list pgsql-performance

From Tory M Blue
Subject 9.1.2 Postgres corruption, any way to recover?
Date
Msg-id CAEaSS0YTeT8ZMt7czBQnzAF1M8zR3P0HU5eKOPxWd7=Jq4-RXQ@mail.gmail.com
Whole thread Raw
Responses Re: 9.1.2 Postgres corruption, any way to recover?  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-performance
Appears one of my bigger, but older DB's cored or other this morning and when it came back up the DB shows that it can't start and is possibly corrupted. I've read this was actually due to a kernel bug sometime back (or at least tied to the kernel bug).

I'm wondering if there was any other work arounds or "tricks" that I may try to recover, vs doing a restore from backup?

2014-02-23 03:46:08 PST    LOG:  aborting startup due to startup process failure
2014-02-23 11:10:09 PST    LOG:  database system was interrupted while in recovery at 2014-02-23 03:46:04 PST
2014-02-23 11:10:09 PST    HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery.
2014-02-23 11:10:09 PST    LOG:  database system was not properly shut down; automatic recovery in progress
2014-02-23 11:10:09 PST    LOG:  consistent recovery state reached at 1493/24398AA8
2014-02-23 11:10:09 PST    LOG:  redo starts at 1493/5306FC8
2014-02-23 11:10:09 PST    PANIC:  heap_update_redo: invalid lp
2014-02-23 11:10:09 PST    CONTEXT:  xlog redo hot_update: rel 16399/868691025/959835680; tid 1180404/38; new 1180404/40
2014-02-23 11:10:09 PST    LOG:  startup process (PID 3175) was terminated by signal 6: Aborted
2014-02-23 11:10:09 PST    LOG:  aborting startup due to startup process failure


Not holding out hope, but maybe just maybe someone has some ideas/shortcuts to maybe get this DB back up

Thanks
Tory

pgsql-performance by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Lack of index usage when doing array casts
Next
From: Tomas Vondra
Date:
Subject: Re: 9.1.2 Postgres corruption, any way to recover?