| 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:22:38 |
| Message-ID: | 4751C28E.1050300@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
Cool, thanks.
I wonder what I'm supposed to do with my debian installation since there doesn't
seem to be any such thing as pg_resetxlog. Or is it hiding somewhere?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Allison | 2007-12-01 20:32:50 | Re: power failure.... |
| Previous Message | Tom Lane | 2007-12-01 19:27:26 | Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible? |