PDA

View Full Version : optimization problem



tylerf13
03-15-2011, 10:05 PM
when I try to optimize, I get this error message:

ERROR: XX001: invalid page header in block 58299 of relation "postflopactions_month"

I get similar errors when I try to do maintenance through pgAdmin.

I've tried exporting HH's from the database but it only gives me about half of them.

Patvs
03-15-2011, 10:59 PM
It's a sign of a corrupt database.
You could try a REINDEX of the database in pgadminIII (so the index "postflopactions_month" will get reindexed and might get fixed)

But ideally, you should just create a NEW empty database, reimport your archive folder.


Before you do that:

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

And consider to update to the latest version of PostgreSQL @ PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)