PDA

View Full Version : error while updating db



Gary
01-06-2012, 05:02 AM
Hey I recently re installed my hem and i keep getting this error


ERROR: XX001: invalid page header in block 176496 of relation "compiledplayerresults_month"

Please close down any programs accessing the database and relaunch Holdem manager.


Not sure what i need to close down as nothing else is open, please help !

netsrak
01-06-2012, 06:50 AM
Your database is corrupt.

Please try a reindex of your database via pgadminIII->maintenance.
If that doesn't help you should create a new database and reimport all your hands (+notes +summaries).

Gary
01-06-2012, 06:26 PM
ok now the update eats through my hard drive space which is very small and not big enough to complete, is there a way to not do this update?

Patvs
01-06-2012, 09:05 PM
A vacuum/analyse/reindex/backup/restore will require a lot of diskspace (nearly the same size of the database).

So if you have all your original handhistories, the best thing to do is create a new database and reimport the hands.
New database: Run dbcontrolpanel.exe--> Database Management--> Connect--> Create New Database--> (set it as default)--> Start HoldemManager

And delete the old database in pgadminIII: http://faq.holdemmanager.com/questions/75/Create%7B47%7DDeleteDatabase