PDA

View Full Version : Error when try to vacuum analyze



DeJvX
10-14-2008, 12:54 PM
When I manually try to vacuum analyze through pgadmin, i get this message

ERROR: invalid page header in block 2433 of relation "pokerhands_idx1"

Any suggestions?

morny
10-14-2008, 01:26 PM
Please try this beta and retry http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe

DeJvX
10-14-2008, 08:00 PM
Same error ...

Any other suggestion?

DeJvX
10-15-2008, 07:47 PM
*push*

Rvg72
10-16-2008, 01:13 AM
1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Click on the Icon at the top that has the SQL and pencil
Type the following:

Drop Index pokerhands_idx1

Then hit the F5 key to run it. Next type in

CREATE INDEX pokerhands_idx1
ON pokerhands
USING btree
(handtimestamp);

Press F5 again and it will rebuild the index and you should be ok

Roy

DeJvX
10-16-2008, 07:17 AM
Thank you! :D