Error during housekeeping process

[greytex]

hi

During housekeeping process i got this message:

There were errors during the housekeeping process:
Unable to execute query: VACUUM;; Reason: Fatal Error (ERROR: could not read block 16631 of relation 1663/16403/133131: Invalid argument )
Unable to execute query: SELECT DISTINCT id_player FROM holdem_hand_player_statistics;; Reason: Fatal Error (ERROR: could not read block 170893 of relation 1663/16403/134285: Invalid argument )

Housekeeping process couldnt finish normaly becouse of this problem. What could be a reason for that? Thank you for help.

[tarix]

From our Postgres SQL FAQ:

There are two main reasons for this kind of 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.
(If the re-index doesn't work because you are not logged in as user 'postgres' enter: "reindexdb -U postgres -a").
You will not see the password as you type so please input 'dbpass' and press enter when prompted for a password.

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.

If you have trouble completing these steps just let us know.

[greytex]

I tried to reindex databes but failed. Some tables was reindexed but than i got failed message :

"reindexing of database PT3 DB failed : ERROR : could not read block 16631 of relation 1663/16403/133131: invalid argument


Still doesnt work. And i also found out that HUD is not working now.

[tarix]

What about the second part?

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.

[greytex]

completed normaly

[greytex]

now i figured that second part failed. I was unable to save changes to file. it wrote that i dont have permision to save changes and need to contact administrator.But im the only one user on this computer and also administrator.hmmm.im using windows 7 64x

[kraada]

In that case:

Start --> Programs --> PostgreSQL --> Configuration Files --> Right click on "Edit postgresql.conf" select "Run as Administrator" and make the changes and then it should save properly.

[greytex]

Still the same problem :(

[kraada]

Did you remember to restart PostgreSQL after making that change?