PDA

View Full Version : Error while Vacuuming database



rgantt
03-04-2010, 03:00 PM
Got this error when vacuuming my database:

ERROR: invalid page header in block 15585 of relation "handhistories"

Is it new database time?

fozzy71
03-04-2010, 04:03 PM
Most likely, yes. You could try to do a general Reindex through PGAdmin, but I would probably just make a new DB if it were me. Are you using SQL 8.3? If so, this is a good time to update to 8.4.

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/postgresql_8.4.2.1.exe