Quote:
Originally Posted by Scrubx
Ok so I'm having issues with HEM currently, I will try to explain everything as properly as possible, though I'm not really sure what's causing my issues > hence I'm also not 100% certain on how and what to explain.
Basically HEM was lagging hard for me lately, so I did a bit of reasearch to see what I can do to up the performance of it.
I did do a PostgreSQL-Tuning and a Full-Vacuum Database Optimization.
Afterwards I wanted to start up HEM and it wanted me to log into my postgres server, I did have some Issues here due to the password but I got that fixed.
So HEM is finally starting up again but now to the key-problem: It doesn't load up my old Database and I somehow don't find an Option to load up my old Database, there is no way I just deleted 2 years worth of Database (I never choosed any option to delete anything).
Plus if I go into this folder path > computer>C>user>name>appdata>roaming>holdemmanager >database there still seems to be my old database simply named "HoldemManager2" - which got created about 2 years ago, so I'm quite certain that's just my old Database?
If I now try to load it it simply doesn't appear in the list: https://puu.sh/woC7C/7f9333a64e.png
So I would assume that my old Database should be in this Dropdown-menu, but it isen't.
The one named Scrubx is basically one I just created now (a blank one) - and the SitNGoWizard2 is some standard thingy from HEM without any Aliases in it etc.
Ugh I feel like I didn't explain my case very properly, but I simply don't really know what I should look for (I'm just a total noob when it comes to HEM).
Maybe you guys still can draw a conclusion from those information? Or perhaps ask me something if there are information missing.
The lagging could have been caused by a damaged database or some other settings but it will be hard to be sure now. Tuning the database can sometimes cause connection issues (if you had contacted us at this point we could have helped you reconnect the server and the old database rather easily instead of what I will have to suggest now) and fixing those issues can often cause the problems you have described, depending on how you try to fix the connection, which at this point can likely only be fixed by reinstalling postgresql manually and pointing the installer to the old database in the program files \postgresql folder or by creating a new database and reimporting the original hands manually if you don't have a backup to restore.
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.
If you don't have a backup and want to rebuild your database manually using the current connection/installation just import the original hands from your C:\HM2Archive folder.
To try and reconnect the old database, if that is what you want to do:
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
If you continue to have problems, please reproduce the problem and
send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing and make sure you include a link to this thread and your forum name so the person replying to your email has all of the background for all of your problems and what we suggested here.
Fozzy71
Customer Support