Damaged database

[bopunto]

My old hard drive went a bit screwy. Something about bad sectors. So it was copied (sans a few bad files in my postresql database that couldn't be gotten) onto my new hard drive.

Now, when I try to vacuum/analyze my database I get an error saying:

An error has occurred trying to perform the requested action. The error was:

7 - SQLSTATE = XX002
ERROR: index "game_players_idx_02" contains unexpected zero page at block 337497;
Error while executing the query

Any way to fix this? I tried vacuum/analyze and just plain vacuum.

I'm using PT2 and XP btw. I also had to uninstall and reinstall postgres as I suspect some files from that were missing. I was getting errors that I found out required a reinstall by searching through the forums.

[kraada]

Moved to the PTv2 forum so you can get a more targeted reply.

[ptrack pat]

You can try reindexing as detailed here
http://www.pokertracker3.com/forums/arc ... ex+pgadmin

You can just reindex the GAME_PLAYERS table as that is the one causing the error.

[bopunto]

Bit of a problem.

Seems like maybe my only option is to start over? Problem being I don't know how to do that either.

[ptrack pat]

If you just click on the PTPGSQL1 database it should connect to it so you can see the list of tables.

[bopunto]

Ah, I'm an idiot.

After reindexing all the tables, the database cached correctly. Looks like a success. Thanks a ton.