> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Cott Lang > Sent: Friday, September 24, 2004 10:21 AM > To: [EMAIL PROTECTED] > 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 ---------------------------(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
