Limits covered: .25/.$50 No Limit, .50/$1 Limit and up to $22 buy-in tournaments

You should be able to search your name and review the hands in HM. HM Archives the hands for performance reasons. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

http://faq.holdemmanager.com/questio...Import+Folders

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).

hmm dont know if i get this. but is it possible to play euro and dollar tables at the same time and HEM detects whats euro and whats dollars?

Thanks !!!

Another question: Do you think that the data could be lost, because i didnt pressed the "stop auto import"-button before shutting down my pc? This would be a pitty...

I have a related problem. I play a lot of $2.20 satellites on PokerStars, and I cash out the wins for $11 in tournament dollars. HEM counts this as $0 won. That's fine, except that when those tournament dollars are used to buy into a tournament, and I don't cash, that counts as a loss.

The bottom line is that since so many of my tournament dollars are counted as losses when used, but not as wins when received, my totals are really skewed, and I have to manually enter all of the satellite tickets as $11 wins to make the totals work.

Hmmm, odd the HEM thread somehow managed to escape from the sub-forum back into the main forum (probably when I merged a thread in here). Will have to try to work out how to stop that happening again.

Juk

I am trying to manually vacuum my database and have no clue what my password is for the SQL database. Is there a retreival or reset mechanism?

I just bought a new computer today. Can you please go over the steps needed to ensure a smooth transfer?

I know that I have to transfer the database and I think that is found in the FAQ.

What about transferring my HEM settings such as my HUD preferences, alias, etc? What other steps do I need to go through?

As a followup, can I just take my "data" folder" from postgresql and copy and paste it to my new computer in the same location? Can I do the same with HEM- copy and paste the "Holdem Manager" folder from my old computer to the same location in the new computer?

hey guys just wodnering if there is any one out there that knows how to delete some stats in HEM ? by deleting i dont mean purging! i mean completely deleting!!... bascially i jsut dont want to ever ever ever see them again .... is that even possible ?

wayne

Try 'postgrespass' ?

thank you for your quick response. i understand you have a lot of customers asking for a lot of things and can't drop everything to cater to everyone.

that pretty much answers my question. i will probably start their trial this weekend and keep an eye out over the next few months to see where you are at and make a decision at the end of the trial.

Anyone?

Answering this and all the other questions now, but it may take me a bit to answer them all.

Small Stakes Version $54.99
Not compatible with most limits. Hide Details

This version is usable at only the smallest games.

Limits covered: .25/.$50 No Limit, .50/$1 Limit and up to $22 buy-in tournaments


I am not sure what stopping a purge could cause tp happen but I certainly don't recommend stopping a purge, vacuum, etc, just like I don't recommend closing HM before you Stop Auto Import.


Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements in my signature - Top 10: HEM performance increase tips


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.
http://faq.holdemmanager.com/questio...+from+Database
http://faq.holdemmanager.com/questions/197/Purge+Hands

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


Can you email us some hand histories and summaries with a problem description? Then we can get a proper support ticket and bug created. Please zip and email the problem hand histories, with a link to this thread, and your forum name, to support@holdemmanager.com


If you have more problems please start a thread on our forums.


Yes, the latest version has multi-currency support. Please update to the latest version - http://www.holdemmanager.net/hmupdate


I doubt it is lost. It should be in the original hand history folder or the \HMArchive folder. It can also be exported from HM assuming it imported properly. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

You should always try to stop the auto import before you close HM, whenever possible.

Make your voice heard in this thread and related blog post - http://forums.holdemmanager.com/rele...ment-regs.html




PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL)


FYI: We are working on a new backup system/method that will hopefully be a one-click > one-file backup solution to simplify this.

Before backing up, make sure you have the latest version of HM - http://www.holdemmanager.net/hmupdate


You should first find and backup your \HMArchive folder. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________

http://faq.holdemmanager.com/questio...Import+Folders

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).


I also recommend you export your database to text files to be sure you have all your hands. You also want to export any tournament results, custom HUDs, and HUD notes. If you have any custom popup or reports you need to backup the appropriate \Holdem Manager\ sub-folders. I recommend you backup the entire folder, after exporting the various files/settings.

Hands, in case moving your DB or backup/restore methods fail - http://faq.holdemmanager.com/questio...6+Export+Hands

HUDs - http://faq.holdemmanager.com/questio...+Configuration

Notes - http://faq.holdemmanager.com/questions/45/Notes


99% of these things are contained in the \rvg software\holdem manager\config folder, in 2 main files. holdemmanager.config has all your basic settings like import and archive folders, filters, etc. prefs.xml contains alll your HUD settings and custom HUDs. The custom HUDs should all be exported individually as well, in case your prefs file ever becomes corrupt or lost.

If your new PC is a different OS, like 64 Bit W7 when you used to have XP, the auto-import folders will be completely different. Make sure you check all settings before you assume they are all the same or copied over the same.


You can do that with your \config folder, but you don't need to (and should not) do that with the other files and folders in \Holdem Manager.

You can try to use your old \data folder, but you need to copy/paste it into place before you install PostgreSQL and you need to make sure you use the same version of postgresql. Even then, there exists a chance this doesn't work, so make sure you have a .backup of the DB and all your original and exported hands.


For reinstalling SQL to the same DB, follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator
[PHP]net user postgres /delete [/PHP]
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://faq.holdemmanager.com/questio...g+Old+Database
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.

Does hem have this feature?

"We also have plans in the future, (although it wont be soon and i dont have an ETA with the current workload) to introduce a new stat that will consider our equity across preflop/flop/turn and what % of our stack was in compared to the equity at the time which will produce a fairer stat in the case where we get 80%+ of our stack in on the flop as a big favourite and then All in EV is only calculated on the turn when the final 20% is gone in so if he hits his miracle card then the calculation would be very different when in fact you got the majority of your money in as a huge favourite but HM calculates it when you were a big dog on the turn."

I play on Merge (Carbon) and with the new release where HM converts the actual HHs I have run into a problem. Before I was using this other program to convert the merge HHs into party poker HHs, which then would be imported to HM. So now that I have switched to using just HM, I am not getting all of my old hands on the players. I think this is because the new ones are storing the player as "playername(Merge)" and the old ones are "playername(PP)".

Any quick way to fix this by merging the old players with the new ones or something?

No but its on the todo list

yeah youll need to either start a new database and reimport the original hands or make an alias would be the easier option http://faq.holdemmanager.com/questio...ame+%26+Alias+

Does 1.10.03 still have the Rush Poker HUD that was present in the last beta?

I'm using Windows XP, Commodo, Avira.

I'm not sure about drivers being up to date. Why would I have to update them? Most video stuff I run works fine, but I guess that could be the problem. I was just wondering if I was the only one who had problems with the replayer. (I guess maybe I am...)

I'm using HEM 1.10, but I will get the latest beta soon. The replayer has always worked poorly for me though.

One more thing- The hyper-turbo sattelites have a glitch in the results. For example the 86+1.72 sattelites award $215 for 1st and 2nd and $86 for third. HEM is occasionally awarding $335 (I think) for 1st $180 for 2nd. I think this happens when there is a multi-way all-in on the final hand, so that instead of two first place finishers it awards one first place and one second. I'm not sure if the other buyins are affected or not.

Thanks.

Also, how do you do a REINDEX? You suggested that in this thread, but I don't see it in any of the menus. Thanks.

hey guys,

I can t get the hud running with 10max tables on Boss media. any ideas? it works fine with the 5max tables...

I also created a new hud. and i am using the mini tables. any ideas to fix it?

Open pgadmin in the postgres folder in your windows start menu.

Select your database and right click --> maintenance --> reindex.

Yes, the hud released with 1.10.03 was still the same hud, well have a new hud release very soon with rush improvements

See this FAQ about graphics card drivers http://faq.holdemmanager.com/questio...cs+Card+Driver

If you spot one of those errors again in calculations please zip up the hand histories and corresponding summaries and send to support@holdemmanager.net with details of the issue and well look into it

Is the hud appearing at all for 10max or just not lining up properly?

Hi, you first need to open pgadmin from Start Menu - Postgresql and then double click on the server name in the list and it will ask you for your password. Most likely it is postgrespass unless you used a different one.

To avoid having duplicate players:

1. Purge all Merge hands from the database
2. Export Hands
3. Create new Database
4. Import hands
5. Run the SQL command provided (using the correct site_id).


Open the Query window by clicking on the icon that looks like a pencil and a piece of paper. In the window that opens replace anything in there with:

update players set site_id = 19 where site_id = 0;
update pokerhands set site_id = 19 where site_id = 0;
update pokerhands_hero set site_id = 19 where site_id = 0;
update tourneydata set site_id = 19 where site_id = 0;
update tourneyplayerdata set site_id = 19 where site_id = 0;


Then press F5 to run it. Launch HM and all your Merge players and hands that were converted to Party should be back to Merge. The problem with doing this if you already imported real Merge hands is you'll have duplicate players in the players table which will probably cause other problems.


It has an updated HUD version.

It is a standard thing we suggest any time someone has replayer or HUD issues, to rule out every alternative.


Please zip and email the problem hand histories, to support@holdemmanager.com


1) Please update to the latest beta - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe
2) If that doesn't help, please answer these questions - http://faq.holdemmanager.com/questio...esn't+Work
3) Post the answers in a new thread on the HM Forums - http://forums.holdemmanager.com/index.php

I've searched this thread but am not sure that the latest update solves the issue with the new Rush table limits, i.e. PLO10 and NL5. The HUD seems to work fine with the older limits but doesn't work with the recently added limits. Is this a problem for everyone or just me? Thanks.