Reinstalled win10 again and it is working now.

Thanks fozzy, you do a good job

Can I ask a quick question about PostgreSQL - I've had intermittent issues for a while now, where I get a message that HM2 cannot connect to the PostgreSQL database. I've tried the steps mentions on the HM2 website and nothing has instantly worked, though usually if I wait and try again later (after re-booting) HM2 will work again. Then it may work for a month, then I'll have another issue.

Is it worth trying to update from version 8.4 to something else? I think that I'd have to uninstall HM2 and then re-install it after updating PostgreSQL?

Thanks!

Which Operating System, Firewall, and AntiVirus are you using? I am assuming Windows 10 which is known to have issues connecting with PSQL after Windows updates. Some AV/FW (Avast, Avira, AVG, etc) can cause it to. Updating to a newer PSQL version might help but I can't be sure. If you upgrade PSQL (will put steps below if you want to try) you should not need to reinstall HM2.

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.

8) You should now be able to restore your database backup.

If there is an issue installing postgresql, 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.

Fozzy71
Customer Support

Thanks - I am on Windows 10 and have no anti virus software (other than Defender, or whatever the inbuilt thing is called). I've refreshed a few times and there are no new updates showing, so I'll try to update PSQL. As I can't get in to HM2 I'll have to back up by the second method.

So, fingers crossed for me!

If HM2 can't connect to postgresql you likely won't be able to backup with either method and will have to recreate your database by manually importing your original hands from the HM2Archive folder.

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.

Fozzy71
Customer Support

Hi,

I'm trying to put WTSD in my hud but there are WTSD (when saw flop), WTSD (when saw turn), WTSD (when saw river).. no naked WTSD..
Where can I find just WTSD?

The one you want is the 'when saw the flop'. There is no WTSD stat based on all dealt hands, only if you actually see the flop.

See the following links for more details about how the stat is defined in general:

http://poker.gamblefaces.com/underst...t-to-showdown/
https://www.pokertracker.com/videos/...-showdown-wtsd

Fozzy71
Customer Support

Is there a stat fold vs delayed cbet?
(when we raise IP, villian calls, flop goes check check and then villian fold to our turn bet)

HUD Settings > HUD Designer > Skipped CBet > 'Skip Flop CB and Fold to Turn Bet IP' (this is near the very bottom of the 'Skipped CBet' category list)

Fozzy71
Customer Support

Hmm but that isn't folding to delayed cbet.. ? It sounds like preflop raiser is folding:
Player raises, xb flop and fold to our turn bet.

The one I'm looking for is: We raise IP, player calls, we xb flop, he x again turn and fold to our turb bet. That would be fold to delayed cbet.

Yes, you are correct. I misread that wrong and our QA/Testing Manager (aka Stats Guru) was not online to check with. I will try and find out if the stat you want exists and quote your last post again when I have an answer.

Fozzy71
Customer Support

You would need to use NoteCaddy Premium to create this stat yourself as it is not included by default in HM2.

Fozzy71
Customer Support

how do i find fold vs resteal stat?
thanks

HUD Settings > HUD Designer > 'RFI/Steal' category or [x] 'Search Stats' = 'fold vs resteal':
- TOT Fold vs Resteal
- CO Fold vs Resteal
- BTN Fold vs Resteal
- SB Fold vs Resteal

Fozzy71
Customer Support

Is there a way I can see the av stats of the the entire playerpool I play against?
I cound't find it, I was thinking about creating an alias with everybody through SQL. Would it work?

If you want to create an alias with a lot of villains you can do it via PGAdmin as explained here or via the new NoteCaddy Premium Aliases feature that creates an alias based on a color definition but please be aware that it can be very resource intensive to link all villains to an alias so you should have a powerful computer with lots of ram if attempting this. This technique can also cause erroneous results if some of the villain's you aliased together have played hands against each other. An alias is designed to join 2 or more hero screen names that would not have played against each other so while this is possible to do it is not something we officially support or recommend.

If you are using NC you can do the aggregate percentages much more quickly than by making an alias.

Fozzy71
Customer Support

vs some players i play in games witch give totally different HUD numbers

can i have the hud only show their stats from that game type, i see it shows different for cash and tournaments....but i want it to show different for different tournament types

SNG example: 6man and fiftyfifties

This is not possible.

Fozzy71
Customer Support

Ok, thx.

I also have a question regarding EV bb/100 in mtts...
Is it incorrectly tracking "Net Won Chips" or am i not seeing/understanding something?
http://prnt.sc/drlwbe
It says i have a positive evbb/100 and bb/100, and im even running above ev yet im still loosing chips, how is this possible?

When i filter for STTs the win rates are just slightly higher but give a drastically different Net Won Chips number
http://prnt.sc/drlzol

One is a big positive number while the other is a big negative number, while my logic says they should both be positive?

thank you

Having a positive bb/100 and negative chips won is entirely possible since you generally play more hands at lower blind levels and win (some) chips at each of the various lower blind levels then lose a lot (most/all) of your chips (but not a lot of bbs) in later higher levels. Try using the Winnings Summary report so you can see chips won compared to those stats by blind level. It should become more clear with that report.

Fozzy71
Customer Support

Yeah, that makes sense.
That would also explain a +7bb win rate and yet being down on mtts more than 5k $.

Hi, i am deleting old database, is it possible to close holdem manager from windows task manager, impot new database and delete old later, old in appdata/roaming/ holdemmanager/database/.... ?

Why do you need/want to close HM2 from the Task Manager? Are you having problems that are preventing HM2 from closing?

Everything you want to do can be done while HM2 is running. Database Manager > New, then delete the old one (this will delete the postgresql \data\sub-folder as well as the \roaming\holdemmanager\database\sub-folder then back to the Home tab > Options > Hand Importing menu to import hands from your \HM2Archive folder.

Fozzy71
Customer Support

I am using version 2.0.0.8079 in order to see all Ignition hole cards. Is it possible to watch the action without seeing the hole cards and turn them on afterwards?