PDA

View Full Version : When I manually try to vaccuum analyze through pgadmin



probability
09-14-2008, 08:35 PM
When I manually try to vaccuum analyze through pgadmin, this message comes up
ERROR: invalid page header in block 132468 of relation "handhistories"

Rvg72
09-15-2008, 11:43 AM
Hi, having an issue in that table is really unfortunate because it can't be recovered. To continue using that DB:

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
5) Type "drop table handhistories" without the quotes and press F5
6) Type (well copy and paste is better)

CREATE TABLE handhistories
(
pokerhand_id integer PRIMARY KEY,
handhistory text,
standardizedhandhistory text,
filename text
)
WITHOUT OIDS;
ALTER TABLE handhistories OWNER TO postgres;

And press F5. It should be good after this.

Roy