PokerTracker

hello,

one day I've got an error message:

Fatal Exception during Auto-Import process: Unable to execute query: INSERT INTO player VALUES (0, 0, '[Split Pot]', '[Split Pot]', 0, 0, 0, FALSE);; Reason: Fatal Error (ERROR: invalid page header in block 95 of relation "player" )

i don't know what the solution can be...
please write me some advises, if you know how I should fix the problem.

thanks

There are two main reasons for this kind of 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 Database Management window - it may take a while but shouldn't take more than an hour or two unless your database is very large.

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.

hi kraada,

the second solution really good...
the system is working now again

thanks for the quick answer

Kraada isn't here today, but thanks for letting us know.