@kasparovski what are you running HEM or HM2?

Making Database backup you guys mean just export hands or other method?

hand export will do, as in you'll be able to recreate a database - but it's super slow. I'd use pg_dump + pg_restore, I think they're made easily accessible available in the pgadmin interface. won't lose any data and fast. worth reading about them. I think the hem/pt might have similar tools available too, not sure.

Im total green in these.

Could you tell me what I can find info how work with this?

you have to open your pgadmin by Start>All programs>Postgresql X.X> pgadmin. Then connect to "PostgreSQL" and insert your user and password if requested and right click on your database.
After that, you can choice the "Backup" option and select the name and folder of your backup file. Make sure that at the end of the process it returns the 0 exit code (means no error).

To restore the database, iirc the correct procedure is to create a new database by HEM, then open pgadmin III, right click on the created database and then choice "Restore". At this point, you have to select the file containing the database backup and click ok. Again, make sure there are no errors at the end of the process.

If you are running HEM1, you have to run the script in the post #11. At the end of that, just before the last ";", you have to insert the code
This code insert the frst 4000 players.

Then you have to insert other 4000 players. Instead of the previous code, running the same query of post #11 inserting
And continue until the end of your players.

yes hm1. tyvm, will try it later.

A brief summary of the things to do to create an alias of all players.


0. Before make any changes in your database, make sure you have a backup.
To create a backup of your database, you have to open your pgadmin by Start>All programs>Postgresql X.X> pgadmin. Then connect to "PostgreSQL" and insert your user and password if requested and right click on your database.
After that, you can choice the "Backup" option and select the name and folder of your backup file. Make sure that at the end of the process it returns the 0 exit code (means no error).

To restore the database, the correct procedure is to create a new database by HEM, then open pgadmin III, right click on the created database and then choice "Restore". At this point, you have to select the file containing the database backup and click ok. Again, make sure there are no errors at the end of the process.


1. After the backup, first of all you have to create an alias for your nicknames. It's simple to do that on HEM: in HEM1, for example, click on Options>Player Aliases, then click on Add alias, choice a name for it (ie Hero) and then add to it all your nicknames clicking on Add Player. I don't use HEM2, but I assume the process is the same.


2. Open your pgadmin by clicking on Start> All Programs> PostgreSQL X.X (for me it's 9.0) and click on pgadmin. Once opened, expand Server and double-click on PostgreSQL X.X (localhost: yyyy). If required, enter the password. At this point you have to expand Databases and click on your database of interest (for me it's SNG HU).


3. Then you have to open the query tools by Tools> Query tools. When the new window opens, make sure you are using the correct database checking the window title (for me it's Query - SNG HU on ...). Then insert the codes listed below. For every code, you have to run it by clicking on Query>Execute (or just press F5). If you have to insert a new code, open a new query window by clicking File>New window (or just press CTRL+N)



At this point the things changes if you are using HEM1 (a) or HEM2 (b).
4.Run this query. It create the new alias 'Global alias' and return its id; note the number, it will serve you in a minute.

a)
b)

5. Assume that the number returned by the previous query is 12345.
Then populate the alias with this code. You have to replace "12345" with the number returned by the previous query and "Hero" with the alias name choosed for your nicknames in step 1 (not your nickname!!! ).

a)
b)

6. If your database has more than 10 000 players, the first time you run the script you have to separate the players in different groups. At the end of code in step 5 (before the last semicolon) insert this code and run it
Then, as above, insert at the end of the code in step 5 this code and run it
Continue until you inserted the whole players.

For the next times you have to execute only code in step 5.


7. Optimize your database. To do it right-click on your database by pgadmin (for me it's SNG HU) and:
a) click on Maintenance, select VACUUM, check FULL and ANALYZE and click OK. When it completes, click on Done.
b) Select REINDEX and click OK; again, at the end click on Done.


8. Now you can close pgadmin and look at your alias on HEM. If you had it opened restart it and ... enjoy!!


NB: I'm sorry for my bad English. Some terms can be different on your pgadmin because I don't use an English version.
Any help with the work on the Global Alias is appreciated.

This is awesome, will be much helpful with some pictrues step by step.

I don't get 5 and 6 step

I made in HM1 Alias names 'Population'.

Open Query, made copy/paste "a) Code" , and what next?

Still don't get it what I have to do with this "12345" and 'Hero'. Im not sure what you mean. Even don't know where exactly paste it.

You are doing great job, its really awesome. Please help me with that. Thank you

you don't have to made an alias as 'Population' by HEM, but by pgadmin. With the query in 4. you create an alias called 'Global alias', that is the same.
By HEM you have to create an alias with your nicknames on different skins; I named it 'Hero'.

Press F5 and run the code

When you execute the first query (by pressing F5), it returns a number. In the second query just replace 12345 with the number you obtained.
'Hero', as said above, it's the alias for your nicknames.

If you have other questions, post it

About PT4, it's difficult to create a 'Global alias'.
But Benjamin opens a 3d in the support forum, and maybe things can change if others support the request
Here the link
https://www.pokertracker.com/forums/...209259#p209259

THANK YOU!!!!!!

Hey Buddy again.

I figure out I made mistake last time I did it, cuz I didn't replace "Hero" with Aliast with my nickname.

I decide I will again open pgadmin and made it again what I did before, but will replace "Hero" by Alias name now.

I made all this and open Holdem manage, choose "Preflop Cards" filter, and:




Edit: Ok I read it few pages before and everything working now! Thank you

I see its only working for "Preflop Cards" options.

I was trying to see how opening % at 25BB deep population tendency is, and when I click "reports" I do not see any hand.

Anyone have same trouble?

works w everything for me. (i am on HM2)

How would you move from HM1 to HM2 by most faster method?

I cant get it to work properly in HEM2.
Either I get a really small sample or it crashes.
Any idea of what it could be?

And its really laggy overall though I have a good computer.

I get the same error message as noskill1 when I try to access the Reports or Preflop Cards tab. I did all the steps mentioned on tigerjack89's post.

I've got about 37k players on my database and I kept repeating step 5 until I got to
"AND p1.player_id >= 35000 AND p1.player_id < 40000;"

Any light here? Hem 1 btw

Thanks

Nice! ty

Well, I think there is some limits in the memory postgresql can use.
A solution coul be to try to run HEM as administrator.

If it doesn't work, try to take a look at this, especially in the sections regarding HEM and postgresql; it is for postgresql 8.x, but I think it works also for 9.x

yeah there has to be an edit to postgresql.conf that bumps up the number of aliases allowed, good thinking!

Sorry for the spam if not appropriate but my beta software creates an alias in HEM/HM2 for different player types (user defined if desired) without having to do the hard work in sql



The software is currently free and will remain so for the foreseeable future

looks cool!! I think a lot of people will appreciate this software!
When I have more free time, I'll test it

Tried the speed tweaks.
http://faq.holdemmanager.com/questio...6+Speed+Tweaks

Damn HEM1 is superfast now. Everything loads instantly.
The dump/restore is really good aswell, better then vacum/reindex i think.
HEM2 and PT4 is still slow as usuall, even thought they run on SQL x64-bit.


Also tweak windows abit in the registry and turned of unnessecary services that windows auto-start. Computer is lightening fast now. Never had a computer this fast before I dont even have time to react.

In fact, it also increased the speed of how fast I can register to tournaments!!

Anyone nows why HEM2 is so F* slow? Takes ages to do anything.
And PT4 allocates all my computer memory after about 2hours (4GB).

So, the problem with alias is solved??
Never used HEM2 before, so I can't help you.
Anyway, to increase also Windows speed, take a look at this
http://www.ocztechnologyforum.com/fo...mp-Utilities-*