Re: [GENERAL] broken xlog - recovery plan check

2012-03-24 Thread Thom Brown
On 24 March 2012 00:45, Colin Taylor colin.tay...@gmail.com wrote: Hi I seem to have an 8.3.9 database with a broken xlog, PANIC:  heap_insert_redo: invalid max offset number My plan is to run pg_resetxlog. Hopefully it then starts up. Test recent data as thoroughly as possible - (script

[GENERAL] broken xlog - recovery plan check

2012-03-23 Thread Colin Taylor
Hi I seem to have an 8.3.9 database with a broken xlog, PANIC: heap_insert_redo: invalid max offset number My plan is to run pg_resetxlog. Hopefully it then starts up. Test recent data as thoroughly as possible - (script some Select * ' s?) If ok - curse ops and their raid caches If not - curse