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
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.