error message when vacummin

[zedjr]

I get this error message when vacuming

there were errors during the housekeeping [process:

Unable to execute query: vacuum full;; reason: fatal error(error: invalid page header in block 31676 of relation "hhps:idx5-id_session")
so what do i do and how to fix,, i get errors when i go to pgadmin also and do a vacuum.
thanks and please dont post if u dont know how to fix as that means otrhers wont bother to look at cause they figured someone has allready posted a solution.

[kraada]

There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command Prompt. At the prompt that appears, type "reindexdb -a" and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.

The second reason for this error is a result of faulty hardware. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.

[zedjr]

thanks for the response,
Can i reindex from the pgadmin,, also wil i have to redo my cache,, as cahce takes a long time to redo??

[zedjr]

ALso i jstu did an unpgrade to recent version of psql 8.3.9 i beleive is current one,, do i need to disable uac when i upgrade version?

[kraada]

Reindexing is different from cache updating; you can reindex from pgadmin if you prefer.

With regards to disabling UAC, we recommend it but I don't believe it's required.

[danbish99]

I am also having the same error. I tried your recommendation of reindexing and was asked for a password. Not being able to come up with a suitable one, I tried the other suggestion, to add zero_damaged_pages = on to the last of the config file. I then ran the database cleanup within PK3 and got the same error at the end of that again- "There were errors during the housekeeping process: Unable to execute query: CLUSTER;; Reason; Fatal Error (ERROR:invalid page header in block 10520 of relation "tourney_holdem_hand_player_statstice") Unable to execute query: VACUUM FULL;; Reason: Fatal Error," etc etc etc.

Any help is much appreciated.

Dan

[WhiteRider]

The default password is dbpass.
If that doesn't work, you can remove the need for PostgreSQL passwords: How To: Remove PostgreSQL Password