Hey guys im curious did anyone else here had problems before with HEM2 and cannot connect to postgresql database and ever had this issue resolved or did most of you just reinstall hem2?


fozzy gave me very good detailed steps on how to fix this issue after looking at the log files but suggests that my files are most likely corrupt. Im curious but do most of you who had this problem, do you basically just uninstall hem2 and then reinstall it but the thing is if u do this, you lose everything in hem2 etc? I think i once did a backup of hem2 on my computer but this was a while back so even that wouldnt have much files etc.


Because this is the first time i ever got this message ever using hem2 and this is pretty frustrating

Unfortunately it is all too common and it is the reason HM3 will no longer use PostgreSQL.

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.

If you have to reinstall just restore your backup then import any hands played after the backup was created from your HM2Archive folder and you should be good to go.

Fozzy71
Customer Support

Hi fozzy thanks for that information. I did do one backup but this was a while back though so im not sure it even have much there. Yes i saw that FAQ on how to back it up but my issue is i cant even access hem2 database due to that cannot connect to postgresql message. And the issues with putting in that as the password on pgadmin3 and it says error etc.

Right, you can't backup now if you can't connect but if your database (and the player/hand notes, etc) are critical to you you should set a reminder to make a backup at least once a month and keep the last 2 or 3 backups. That way if this happens and you have to reinstall PostgreSQL you will have a few recent backups. All that you lose out on if you don't have a recent backup, and the steps I sent you to reinstall postgresql and reconnect your old database don't work, is your player/hand notes for the most part. All of your original hands are stored in C:\HM2Archive and can be imported to HM2 manually if you have to completely reinstall PSQL.

Fozzy71
Customer Support

The thing is assuming i dont care about any database and just want to reinstall HEM2 again where i have nothing there, that would be very easy as just uninstall hem2 and it would uninstall hem2 and postgres? Then if i go and install hem2 again from the website, then it installs that and postgres then i would be starting fresh and brand new? But if i do this, would the folder where i have my hud configuration saved still be there? Thus i would not want to do that again but not only that, i dont remember my hud config as i had few of them.


Also would that mean i could still import the very small backup i have saved of it back into the newly installed hem2? Of course the issue is i know that backup is very small. Im thinking this would be my last resort which is what i assume the easiest would which would mean i have all the hands from hem2 gone etc. But is there a way to find out if that is still there? Im not sure where that is in my computer. I did however was able to check HRArchive and saw folder for pokerstars, 888 and when click on it, i could see the month and dates and thus those are the hand histories?


I obviously dont want to do this as it would delete everything in my hem but the way to backup it up when you cannot even access hem2 due to cannot connect to postgres is just really frustrating since the password i put in it postgrespass doesn't even work and shows error etc.

Just saw your post right now. So yes i cannot do any backup now as im aware.

So that means i cannot do this below?

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.


I do see that HMArchive folder that shows a pokerstars, 888 and even partypoker folder. It shows the months and days i played when i click on each folder.


Im confused here since you mention those could be imported to HM2 manually. So if that can be done, then im very confused with the backup. Because that means all i lose are the player/hand notes on those players i put a note on? What do you mean exactly by this? You mean just the notes i put down on them and like a color code i give each of those players? Thus only those 2 things? If so, that isn't that bad. I had thought it wouldn't show their 1000 hands i had on them and their vpip/prf stats and it would start all over again.


I wouldnt want to spend a lot of time on this as i never had much notes on players. So based on that, i should just uninstall hem2 and reinstall it? Or uninstall postgres and hem2? I had thought uninstalling hem2 would uninstall postgres as well. And when installing hem2, it would also install postgress?


But is that hmarchive folder still there even after i uninstall hem2?


But as of now does it mean i already lost all my player/hand notes based on me telling you i cannot access hem2 and because typing in that postgrespass as my password give me an error? Or it can still be done? I dont mind spending a bit of time doing this to get my player/hand notes back until i saw the issue i had with the postgrespass password. I checked in the forum and few ppl mentioned they had very similar problem on the hem forum on this a while back... I am also pretty sure i did create one backup but this might been a little while ago. But not sure if its there at the moment as i wouldnt know how to check it.

Wanted to add. So how do i know if the hands in my hm2archive folder are corrupt or not? Is there a way to check this right now? I recalled back then when i had issues with hem2, i would completely uninstall it and reinstall it and then brand new. I never recalled uninstalling or installing postgres. However this might been holdem manager 1. But when you say request all hands and summaries from the poker site, you mean request all those from pokerstars, 888 etc, how far would i request back to? This laptop only has a good amount of hands saved but not that many as this was a newer computer i bought not that long ago last year.


So this is just very confusing to me as i even saw in that page you linked me this instructions are for more advanced users and well i just have basic computer knowledge.

Reinstalling HM2 (or PostgreSQL) will not affect your HUDs or other settings.

There is no reason to uninstall HM2. You have to uninstall PostgreSQL using the steps I sent in the 2nd part of my reply to your support ticket.

Here are the steps again for a clean postgresql installation:

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).

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.

If you cannot access the database in HM2 then you can backup your database using this method 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.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Delete the \PostgreSQL\X.x\data folder that is left behind.

3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

4) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete

After you click 'Enter' for the code above also do that same for this code:

sc delete postgresql-8.4

and click 'Enter' again.

5) Restart your PC

6) Install PostgreSQL 9.3 from here.

7) Once installed you should disable the postgresql logging as instructed here.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file. If you can't see it, turn off the windows option that is hiding that directory.


You can restore the database then import the orignal hand history files from your C:\HM2Archive folder and you should be all set. You do not have to worry about duplicate hands in the database. The importer will skip duplicate hands that are already in the restored database.


As I said: There is no need to reinstall HM2 to fix postgresql but even if you did it would not affect your HM2 settings. Just an FYI, not related to your issues: People that have a working postgresql connection can reinstall HM2 and it will not affect their database either.

Correct. If you can't connect to postgresql or pgadmin you can't backup using either method.


Correct. All you miss out on if you dont have a backup to restore is the HUD notes, color codes, hand markings and hand notes that you make in the hand history viewer.

There is no reason to uninstall HM2. Uninstalling HM2 will not uninstall PostgreSQL or delete your databases. Follow the steps above (or in the support ticket) to uninstall PostgreSQL. If you are not going to try reconnecting to the old database using the steps I sent in the first part of my support ticket reply you can then also delete the leftover \data folder in the PostgreSQL\Data folder it leaves behind and the other part of the database in your C:\Users\UserName\AppData\Roaming\HoldemManager\Da tabase folder.

If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio...es+in+Windows+


Yes. If you uninstalled HM2 (there is no reason to uninstall HM2) that folder will not be touched. This is by design so you always have your archived hands to be able to reimport to a new database.



There are ways to fix postgresql connection issues on our FAQs that I linked you to before without having to reinstall/reconnect the old database as I instructed in the support ticket email. The first link is what you should try first if you want to try to save that database, and the 2nd link in the previous sentence is what you try if the first link doesn't work.

There is also a FAQ if the only problem is the PostgreSQL password but I don't think that is your issue as there is no reason your password would have channged unless you installed some other program recently (like PT4) that uses a different version of PostgreSQL and a different password.


Your database or postgresql connection is corrupt, not your original hand history files. The hands should import fine.

If you play a site like stars/ftp/party you can email their support and ask for all your old hand histories and tourney histories/results. 888/Pacific won't send you your hands in their original format (it's some other format) so HM2 can't import those hands, only the emailed hands from stars/ftp/party can be imported.

Fozzy71
Customer Support

2) Delete the \PostgreSQL\X.x\data folder that is left behind.

3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).


I removed postgressql from remove programs.

I deleted the postgresqul folder in the local disk.

For the 3rd step i got there by this pc- local disk- users- paulyjames- appdata-roaming-holdem manager - database.


The folder is called database. This is the folder to delete correct? Because when i click on database folder, it goes to holdemmanager2 folder, then 2 more folders show up importing and players. Thus you say delete the subfolders so u mean just delete that one folder called database which would delete the subfolders inside? Or do you mean delete the holdemmanager2 folder which would delete the
importing and players folder?


There are other folders above and below database like autorate, chat, configure, filters, fishfinder, importing, logging etc....

I am replying to your support ticket now. Please do not post the same things here that you post in the support ticket as we end up having to spend twice as much time replying to your duplicate posts/emails. Please keep everything contained to the support ticket going forward.

Fozzy71
Customer Support

You want to delete the folders inside the \database folder, not the database folder itself.

Please see my post above. I am replying to your support ticket now and you should receive the reply soon.

Fozzy71
Customer Support

I deleted those 2 folders importing folder and players folder. It was about 800mb or so. Im confused here because aren't those my hand histories etc? I deleted this because i saw this as a step u list here but when i looked at the support ticket you sent me, i dont see anything mention about deleting this folder.

okay i will reply back to you there thanks

Those folders/files are part of the postgresql database. Your original hand history files are in the C:\HM2Archive folder.

Fozzy71
Customer Support

hi fozzy i replied back to your response on the support ticket. So just to make sure, those 2 folders i deleted... one is importing folder that is 0 bytes, the other one is Players folder and thats 737mb, those were the 2 folders that were correct to delete? Yes this is the last message im going to type on 2p2 as im duplicating my posts.

Yes, those are the proper folders to delete if you are following section b of my original reply to completely reinstall postgresql from scratch.

Fozzy71
Customer Support

alright thanks. i will just leave them in the recycle bin just in case. I will reply everything on this topic in the support ticket from now on.

Hey, my HM2 seems to not be registering some of my hands played at the zoom tables. It seems to skip some hands for about 3-4 minutes of play. Let's say that it registers them from 19:00 to 19:30 but then it fails to register hands played from 19:31 to 19:34.

I even used my F9 hotkey to save a hand for later review as per usual and it hasn't e=registered that hand either.

Some other relevant info: Poker Stars's hand replayer (zoom) also seems to skip some hands and not register them at all (it's as if tho these hands weren't played out)

It's a Pokerstars bug unfortunately, some hands are going missing.

The post after yours is correct.

Someone on reddit posted an email reply from Stars support taking credit for the bug. You will need to request your hands from their support since the bug was introduced then manually import HM2 to get the missing hands in your database.

Fozzy71
Customer Support

It feels as tho my won 200bb pot hands are not being registered in HM2 but also they might not be credited to my account as well. Also I'm missing some pots where I win 40bbs.

How can this just be a thing that passes by? It's making me really paranoid that these pots are not being credited to my stars account. My graph also seems to register only pots where I either win or lost 1bb and the occasional 10bb pots. I'm definitely missing some 200bb pots and I suspect that I'm missing those from my balance as well.

You have to request the hands from stars and import them to HM2. As to if they are credited to your stars account you need to verify that with their support. We can only import hands that are written to file on your computer.

Here is the reddit link I referenced.

For older hands and tournaments email support@pokerstars.com and ask for ALL your old Hand Histories and Tournament Audit Files in .htm format. They will send you an email with links to zip files of your hand histories. Download all the zip files. Right-Click > Extract the contents of each zip file to a new folder and then manually import those files by going to the Importing option in the HM Ribbon menu and choosing import from folders in the manual import section. You may see import errors as some of these hands are probably already imported.

The tournament summaries should be attached to the email as .htm files. Download the attachments and repeat the process of importing all the files. If the files are sent as .html you will need to rename them (Right-Click > Rename) from .html to .htm extensions otherwise they will not import. You can view this FAQ for more information on importing emailed hand histories.

Any tournament with more than 1 table (and many single table games) will require a separate Tournament Summary/History file to be imported for HM2 to properly calculate the size, places, and prizes. Without this information its impossible for HM2 to know the correct results. If you have any discrepancies you will need to edit the results manually.

Fozzy71
Customer Support

I'm probably just being paranoid about the money not being credited to my account. Thanks for all the info.

I have several thousand hands from HUSNG and I'd like to create a hand range (weighted) from villains' cards. I can't find any way to do this in HM2. Can I visualise/create a range based on villains' sample? If not does anyone know of a third party software that I can export to?

Thanks

LET

P.S. - I thought I posted this yesterday. Apologies if it's found elsewhere.

People have been discussing this for weeks and you're the first person to mention it affecting account reconciliation - I'm sure it'd be a lot bigger debate if it was affecting accounts in that way. Just my two cents. Maybe single table a session and assure yourself.