| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: production server down |
| Date: | 2004-12-18 22:42:29 |
| Message-ID: | 200412182242.iBIMgTm24674@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2004-12-18 23:24:59 | Re: Call for port reports |
| Previous Message | Joe Conway | 2004-12-18 22:28:51 | Re: production server down |