Open Side Menu Go to the Top

03-25-2009 , 04:21 PM
I'm trying to get rid of my database and the program will not allow me.

when attempting i get the following response


unable to execute query: DELETE FROM holdem_cache;; Reason: Fatal Error (ERROR: could not open relation 1663/16403/17086: No such file or directory)

help please?
Problem purging database
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Problem purging database
03-25-2009 , 05:00 PM
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").

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 are registered, you can always just create a new database (Database > Database Management > New) and then delete the old one.
03-25-2009 , 05:15 PM
when trying the command prompt, reindexdb -U postgres -a, it asks me for a password?
03-25-2009 , 05:19 PM
and yes the computer has crashed recently, but the hardware is fine now
03-25-2009 , 06:34 PM
The default password is dbpass.
If that doesn't work, you can remove the need for postgres passwords: How To: Remove PostgreSQL Password
03-25-2009 , 06:56 PM
thanks for everything
Problem purging database
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Problem purging database

      
m