by Ghostsuit » Thu Feb 23, 2012 3:11 pm
Yeah the reindex did nothing and I tried putting the zero_damaged_pages = on. It's not changed anything, I've checked in pgadmin and it's definitely ticked as option in config. For some reason doesn't seem to be ignoring the file.
Doing an analyse on the database I get this error
"INFO: analyzing "public.cash_hand_player_statistics"WARNING: invalid page header in block 71900 of relation base/108912/108941; zeroing out pageWARNING: invalid page header in block 78604 of relation base/108912/108941; zeroing out pageINFO: "cash_hand_player_statistics": scanned 30000 of 90309 pages, containing 361553 live rows and 0 dead rows; 30000 rows in sample, 1088383 estimated total rowsINFO: analyzing "public.live_cash_player""
Anyway I could manual correct that or is the data just trashed and I'll have to suck it up losing a few weeks stats? Not a major biggy as I've only played about 10k of hands in that time.