Quote:
Originally Posted by Chaos_ult
So last night, my Windows 10 laptop hard crashed. Tried to recover Windows without success.
I was able to salvage C:\users\myprofile\appdata\roaming\holdemmanager and c:\HMarchive from a cmd prompt. I also saved c:\postgresql, but it didn't look like much was in there.
Is my database recoverable from this?
If not, it's a hard lesson in backing up my data periodically I guess, sigh.
Thanks in advance.
If you have a C:\users\myprofile\appdata\roaming\holdemmanager\d atabase and c:\postgresql\data folder you might be able to, if you reinstall the exact same version of postgresql with the steps below. Otherwise you would have to restore a backup file (if you have one*) or just manually import your original hands from the C:\HM2Archive folder. C:\HMArchive = HM1 so I am not sure if your HM2 hands are in that folder you mentioned.
*This is why regular backups are a good idea. If your database becomes corrupt, or you have hardware problems, 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.
Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL -
http://hm2faq.holdemmanager.com/ques...onfigs+work%3F
If you cannot access the database in HM2 then you can backup your database using this method:
http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.
Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.
1) Uninstall PostgreSQL from the Windows Control Panel.
2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:
net user postgres /delete
3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.
4) Reboot your PC
5) Install the same version of PostgreSQL (HM2 ships with 8.4) -
http://www.enterprisedb.com/products...wnload#windows - as your previous database using these instructions -
http://hm2faq.holdemmanager.com/ques...rving+database
http://www.holdemmanager.com/downloads/postgres84
Fozzy71
Customer Support