Joe Conway wrote: > We then spent most of the next 24 hours reviewing the recovered > database. The bulk data loading process was well instrumented, so we > knew exactly which data should have been committed prior to the server > hang, and which files were inprocess (we had been doing 10 loads in > parallel) at the time of the hang. The results of the investigation > indicated complete recovery, with no missing or unwanted (i.e. > uncommitted records looking committed) data.
Good analysis. Seems you were lucky in that only WAL was corrupt and not the heap or index files. -- 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 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
