Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: power failure....
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Tom Allison <tom(at)tacocat(dot)net>
- Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: power failure....
- Date: Fri, 30 Nov 2007 22:48:57 -0500
- Message-id: <10739.1196480937@sss.pgh.pa.us> <text/plain>
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
- References:
- power failure....
- From: Tom Allison
- power failure....
- Prev by Date: Re: Will PG use composite index to enforce foreign keys?
- Previous by thread: power failure....
- Indexes: