postgreSQL error while playing, database deleted itself

[korfadevon]

hey while i had hm2 open while playing i got a postgresql error (i sadly didnt took a screen shot of the exact message) and hm2 shut down. upon restart the "connect to postgresql Database" window showed and i clicked on "start service". hm2 now created a new databse and works again, however my old database seems to be gone? is their a way to retrieve my old database? i have a backup from 2 weeks ago, however i want to know if there is a way to safe my hands from the period between the back up and the error.

[udbrky]

A) Please try to vacuum/analyze and reindex your database - http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance

B) If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - http://hm2faq.holdemmanager.com/questions/3091/How+to+create+a+new+database+and+import+previously +played+hands

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F

C) If none of that helps please zip and email the problem hand histories to us using the 'Contact Support' link here - https://support.holdemmanager.com/support/product/1

All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31) or if it was auto-imported with 7283+ it would be in \HM2Archive\SiteName\YYYY\MM\DD.* It is configured in the Site Setup - Auto Import Folders menu.

When sending any files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then 'copy public link' and paste the download link directly into the support ticket email.

[korfadevon]

I was able to solve the issue by doing what you recommend in b). Thx for support!

[udbrky]

You are very welcome. Thank you for letting us know it solved your problems. It helps us when crafting future replies to other customers with similar problems.

Good luck at the tables. If you have any further questions or problems do not hesitate to ask us.