I don't think there is any easy way to do this. It would likely be possible via some sort of SQL Query but I wouldn't know to create the query.

Make sure the HUD Options > Site Options > Full Tilt are all disabled.

Options > Configure Auto Import Folders... > Auto-Detect > OK

Did it add 2 new folders? Hopefully that is all that is needed to get it working.

If it didnt add any new folders to the auto import list and/or you still cant get the rush HUD working, email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.net/teamviewer. Please let me know what time zone you are in and what time/days are convenient for you. I schedule support from 9:00 - 18:00 EST, 7 days a week.

I get a error message every time I try to scan tables using table scanner

Trying to filter out some hands to get idea how many times I encounter given situation and see that some hands are shown twice. Why this is happening? Obviously I get wrong information and can not make further decisions based on wrong number of hands. Filters are as shown below

What is the specific error? What site? Client or Server side scan?

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe


This is on the Tourney Hands tab? Do you get duplicates for the same date/time stamps if you clear all the filters? The duplicate hands only appear if filtering? Have you tried a new database to see if it is a problem with your current DB possibly being damaged?

Fix the hypers please!

I play 20-50bb tables only on PS but purchase a ton of HH's from a datamining site. Is there anyway for me to purge the 50-100bb tables from my DB? Or is there a way to mark those hands so they don't import into my DB? My DB is getting massive now and I don't need at least half the hands that are in there.

Thanks for any help

It is a known issue but I do not have an ETA for a solution.

No, this is not possible. Purging hands will help reduce the database size some while keeping the HUD stats.


Logging:

I would suggest you turn off logging on your new installation.


To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.



File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.


- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.



Regarding database maintenance:

You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. You do not want to purge any Hero hands so make sure your alias is properly configured before purging.
http://faq.holdemmanager.com/questio...+from+Database


Then you can vacuum/analyze - http://faq.holdemmanager.com/questio...tabase+#manual

Before you defragment you should stop the PostgreSQL service:

Start > Programs > PostgreSQL 8.x > Stop Server

Use your favorite defrag tool. I recommend Smart Defrag.

After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.

Start > Programs > PostgreSQL 8.x > Start Server

This apparently was the problem.

It works now, thanks a lot again!

Yes, this is tourney tab. I cleared all filters except a specific date (otherwise i will wait 2 mio hands to pop up forever) and still get duplicates. Created new database, imported only one day of hands, and there are no duplicates with filters on and off. So, does that mean my database is damaged? Any ways to restore it? Recently I made purge and vacuum/clean. Could it be a reason?

Databases can become corrupt for a variety of reasons. Regular maintenance will help reduce the chance of corrupt databases if you start early. I sometimes see people that have a corrupt database after maintenance, if it is the first time they have (ever) performed maintenance in a long time on a big database.

If you have a recent backup of the database you should be able to restore it and then import your missing/recent hands played since creating the backup. If you dont have a recent backup file you will need to reimport all your original hands.

Hi,

Just yesterday when I was trying to start my HEM, it says it couldnt connect to the server, and that "the connection to PostgreSQL could not be made."

Can you tell me how I could fix it ?

Make sure windows is fully updated and change your Windows Control Panel > Regional Settings Format to English (USA).

This is usually a firewall or windows update issue.

http://faq.holdemmanager.com/questio...rt+PostgreSQL+

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questio...ender+Problems

Please try following these FAQs, step by step:

1) http://faq.holdemmanager.com/questio...rt+PostgreSQL+
2) reinstall the same version of postgresql, using the same \data folder - http://faq.holdemmanager.com/questio...g+Old+Database
3) http://www.holdemmanager.net/forum/s...ead.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloa...ager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
[PHP]net user postgres /delete [/PHP]
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloa...3.9-v1.0.7.exe

Well, seems to be my fault, as far as I remember this was firs time I ever did maintenance. So I have to reimport all hands.
One more question. What filter should I apply if I want to see al hands I shoves preflop? Allin=True filter seems to show only hands that were called, but I need all, called or not

SNG EV question; shouldn't I be awarded 34% (my preflop win%) of the prize pool for this hand in $EV seeing as villain busts if I win the hand? How come I get 0. Or maybe I don't understand how it's supposed to work?
Do I only get positive $EV if I bust out of the tournament? I though I'd get +$EV in hands where I have villain allin and he wins the hand.

Poker Stars $6.00+$0.25 No Limit Hold'em Tournament - t10/t20 Blinds - 2 players

Hero (BB): t2940 147 BBs
BTN/SB: t60 3 BBs

Pre Flop: (t30) Hero is BB with 6 8
BTN/SB raises to t60 all in, Hero calls t40

Flop: (t120) 7 J 2 (2 players - 1 is all in)

Turn: (t120) K (2 players - 1 is all in)

River: (t120) Q (2 players - 1 is all in)

Final Pot: t120
Hero shows 6 8 (high card King)
BTN/SB shows T 6 (high card King - Queen+Jack+Ten kicker)
BTN/SB wins t120

tx fozzy
I just reinstalled the whole stuff

Is there currently a way to have HEM show the 'all in equity' from the point in which two players are all in? Sort of like what you see on a Poker Pro table when players are all in? I thought I saw someone doing this with HEM on an instructional video. If not live, maybe during the hand review that pops up right after the hand has ended.

Player 1: 5s5d
Player 2: 7d8d

Player 1 shoves all in on board: 9d3d2c
You'd see Player 1 has about 43.7% and Player 2 56.3%

This would just help me and other is in NLH and Omaha identify spots where they were clearly not the favorite despite what they thought.

The hand above last night I saw at flamingo. Player 1 insisted he made a great call for all his chips when player 2 semi-bluffed all in. Granted player 1 had him beat on the flop but will lose $ in the long run.

I am not sure, and Filtering is my least favorite thing, right after trying to answer EV questions.

I tried asking my co-workers via Skype but got no answer. I will send an email and see if one of the other guys can help explain how to do it. Once I get an answer I will reply here.

I believe your interpretation is right, but I am no expert with EV. There are some known issues currently with HU SNG EV that the programmers are working on. I just forwarded a couple more tickets with hands this weekend. Please www.7-zip.org the hands and email them to me at fozzy@holdemmanager.net.

I'm trying to vaccum my DB and I keep getting an error that says:
"ERROR: out of memory
DETAIL: Failed on request of size 146."

Is there anyway to fix this?

For some players those stats might change, if they play differnet/mixed games, or at different levels (which means that their default style might be adjusted for the difference in level of competition).

For example, on one of the 2+2 Pokercasts it was mentioned that though Sean Deeb is successful at the highest levels of online tournament play (such as SCOOP or WCOOP high buy-ins) in his day-to-day grinding he often plays much lower.

I'm not sure I understand what you're saying - the overall/total stats are still not gonna change much over a few sessions regardless of whether you play different levels?

Your stats at the different levels may be different, but overall stats, if you have a reasonable number of hands, won't change much. If you have few enough hands that one session will change your numbers a lot, then the session-stats are probably just as good for how your opponent will view you.

I play HU and I want to know how often my opponent is raising me from the BB when I limp the SB which stat do I use for that?

Is this with PGAdmin or our Optimization feature?

Have you tried the Tuning option yet in HM DB Management to optimize your postgresql memory settings for your PC?

http://faq.holdemmanager.com/questio...s+Optimization


I googled your error and it seems to be either caused by config settings not allocating enough memory for certain postgres processes or by corrupt databases.

If the auto tuning doesnt help the problem, you can try manually editing the file to see if you can get around the error.

http://faq.holdemmanager.com/questio...tgreSQL+Tuning


I dont think there is one single stat to reference this. The Raise First or BB PFR stats may be of some help, but I dont think they are exactly what you want.

Hi, trying to restore a database of size 2GB. It's been going for 3 and half hours now, and it only has 1 line in the restore window so far(location of pg_restore.exe). It also says not responding at the top of the restore window, but that's probably normal right?
Probably not holdemmanagers problem but was getting a little bored.. :-\
just wondered if u had any advice for me please?

since today my holdem manager doesnt correct for allin EV preflop anymore, is it possible I accidently changed any settings or is there another solution?

Ignore my last post, it finally finished.