PokerTracker

I can no longer import hands, each hand hand I play has its own error:

Error: PokerStars: Unable to import hand (#85275190863). Reason: Unable to execute query: COPY cash_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 284442 of relation base/33166/43418 CONTEXT: COPY cash_hand_player_statistics, line 1: "472866 1 13 13 100 4 100691 2012/08/26 19:39:48 6 9 9 0 f 0 f t f 0 f f 0 f 0 f f f f f 0 f 0 f f f ..." )


When I try to reindex through housekeeping (as someone suggested) I get this message:

Unable to execute query: REINDEX DATABASE "PT4 DB";; Reason: Fatal Error (ERROR: invalid page header in block 284442 of relation base/33166/43418 )

The second reason for this error is a result of faulty hardware.

You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf.
In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file.
Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data.
If you continue to have problems with that hard drive, you should consider replacing it.