PokerTracker

Hi,
I use PT2 on top of PostgreSQL 8.2
The original problem was that while running backup (or vacuum) process, the tool exited with the following error message:

postgre ERROR: could not read block of relation XXXX / YYYY / ZZZZ

I browsed the internet and forums suggested to run checkdisk for potential disk issues. I did it and indeed, checkdisk found bad clusters exactly in file named XXXX, and fixed it (or tried to fix it). After this, I am getting an error message of new type:
...
...
INFO: vacuuming "public.game"
ERROR: invalid page header in block 34799 of relation "game"

In general, everything works normally, I can upload new hand histories, view stats, etc'. But I cannot do a backup and/or DB maintenance which means I can't move the DB to another PC and I have to do soon.

What are possible solutions? Is there a way to manually delete a corrupted chunk of the 'game' relation? I believe it won't make a lot of harm. Bottom line, I need to be able to backup the database again. Thanks in advance for help !!

I'll move this to the PT2 section of the forum.

thanks,
in any case, I believe it's a general Postgre SQL issue, unrelated to the version of PT software.

What name and email did you use to purchase PT2? I have no record of your name/email used for the site.

I've sent you a PM.

...

I have a similar problem. In which .conf file...

kweigelt wrote:I have a similar problem. In which .conf file...

What name and email did you use to purchase PT2? I have no record of your name/email either.

ptrack pat wrote:

kweigelt wrote:I have a similar problem. In which .conf file...

What name and email did you use to purchase PT2? I have no record of your name/email either.

wrote you a PM