| From: | Tom Allison <tom(at)tacocat(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: power failure.... |
| Date: | 2007-12-01 20:32:50 |
| Message-ID: | 4751C4F2.7030404@tacocat.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Tom Allison <tom(at)tacocat(dot)net> writes:
>> 2007-11-30 19:35:20 EST PANIC: could not locate a valid checkpoint
>> record
>
> Ugh :-(. pg_resetxlog should get you back into the database, but it's
> anybody's guess whether and how badly the contents will be corrupted.
> I would recommend trying a dump/reload and also doing any manual
> consistency crosschecks you can think of.
>
>> postgres version 8.2 sitting on a Reiser FS on RAID1....
>
> Better take a second look at your disk hardware configuration. At least
> in theory, this Can't Happen if your disk hardware is handling fsync
> honestly.
>
> regards, tom lane
I tracked it down and did a reset.
I only have one large table right now.
And now I've decided to start using fsync=on!!! :)
I don't think I want to "test" this just yet...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-12-01 20:34:58 | Re: power failure.... |
| Previous Message | Tom Allison | 2007-12-01 20:22:38 | Re: power failure.... |