PDA

View Full Version : Help needed: Can't Vacuum HEM/Postgres



Stosh
05-20-2009, 12:22 PM
I am more than willing to pay for any help with this problem. A transfer on Stars or FTP to anyone who can help.

On my old computer, I had no problem vacuuming. Unfortunately, on my new setup it fails to vacuum my database.

Vacuuming in HEM results in this message, immediately after initiating the process.
http://i227.photobucket.com/albums/dd204/Stoshilman/Misc/hem-2.jpg
Obviously, it has hasn't succeeded, and I am receiving a false message.

When vacuuming through pgAdmin3, I receive the following error message.
http://i227.photobucket.com/albums/dd204/Stoshilman/Misc/pgadmin.jpg


Thanks for taking the time to look.

morny
05-20-2009, 12:56 PM
It looks like there is a corruption in one of the tables, Please export your hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database and then run the vacuum again