> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org 
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Cott Lang
> Sent: Friday, September 24, 2004 10:21 AM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] CRITICAL HELP NEEDED! DEAD DB!
> 
> 
> Sep 24 10:22:37 snafu postgres[18306]: [2-1] LOG:  database 
> system was interrupted while in recovery at 2004-09-24 
> 10:21:41 MST Sep 24 10:22:37 snafu postgres[18306]: [2-2] 
> HINT:  This probably means that some data is corrupted and 
> you will have to use the last backup for recovery. Sep 24 
> 10:22:37 snafu postgres[18306]: [3-1] LOG:  checkpoint record 
> is at 9A/C2022368 Sep 24 10:22:37 snafu postgres[18306]: 
> [4-1] LOG:  redo record is at 9A/C2022368; undo record is at 
> 0/0; shutdown FALSE Sep 24 10:22:37 snafu postgres[18306]: 
> [5-1] LOG:  next transaction ID: 197841225; next OID: 
> 715436086 Sep 24 10:22:37 snafu postgres[18306]: [6-1] LOG:  
> database system was not properly shut down; automatic 
> recovery in progress Sep 24 10:22:37 snafu postgres[18306]: 
> [7-1] LOG:  redo starts at 9A/C20223B0 Sep 24 10:22:37 snafu 
> postgres[18306]: [8-1] PANIC:  btree_insert_redo: failed to 
> add item Sep 24 10:22:37 snafu postgres[18299]: [2-1] LOG:  
> startup process (PID
> 18306) was terminated by signal 6
> Sep 24 10:22:37 snafu postgres[18299]: [3-1] LOG:  aborting 
> startup due to startup process failure
> 
> 
> Any suggestions to recover?!  I'm dead in the water!  Please!!!

When did you do your last backup?

This message is a clue:
"HINT:  This probably means that some data is corrupted and you will
have to use the last backup for recovery."

If you do a restore from your last backup, you will lose the data
between that time and the time of the problem.  Any other solution will
be fraught with peril, I think.

Otherwise, maybe something here will help:
http://svana.org/kleptog/pgsql/pgfsck.html

Fri, 24 Sep 2004 11:37:29 -0700
"Dann Corbit" <DCorbit@connx.com>
Re: CRITICAL HELP NEEDED!  DEAD DB!

Does pgfsck work on 7.4.x?


> 
> Otherwise, maybe something here will help:
> http://svana.org/kleptog/pgsql/pgfsck.html
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


Fri, 24 Sep 2004 12:20:50 -0700
Cott Lang <cott@internetstaff.com>
Re: CRITICAL HELP NEEDED!  DEAD DB!