PokerTracker

At the end of housekeeping I get the following error message:

There were errors during the housekeeping process:
Unable to execute query: REINDEX DATABASE "PT3 DB"; Reason: Fatal Error (ERROR: concurrent delete in progress )
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: invalid page header in block 64175 of relation "holdem_hand_player_detail" )
Unable to execute query: ANALYZE;; Reason: Fatal Error (ERROR: invalid page header in block 64212 of relation "holdem_hand_player_detail" )
Invalid PostgreSQL connection object

What can I do ?

There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the Housekeeping menu.

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.