Please provide a PostgreSQL version and operating system information. ---------------------------------------------------------------------------
Andrew Sukow wrote: > Greetings, > > Our postgres system crashed and upon restarting it our database had the following > errors. The error log was 4.5 gigs which is much larger than usual. We looked > online for information about lost left siblings and how to fix the data and not lose > the 400 million records we have. Anyone have an idea what's the matter and what the > fix is? > > LOG: database system was interrupted while in recovery at 2004-08-17 08:59:41 PDT > 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 326/C007B778 > LOG: redo record is at 326/BD899570; undo record is at 0/0; shutdown FALSE > LOG: next transaction ID: 46922114; next OID: 133662911 > LOG: database system was not properly shut down; automatic recovery in progress > LOG: redo starts at 326/BD899570 > PANIC: btree_split_redo: lost left sibling > LOG: startup process (PID 9038) was terminated by signal 6 > LOG: aborting startup due to startup process failure > > Thanks, > > Andrew > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
