Small free space on SSD and other problems

[marius]

hi!

here is what I did until now:

-few days ago I did try to Import my DB from HM1 to HM2 didnt work it was only importing very few hands for some reason.
-so yesterday decided to move to HM2 from HM1,with only ~7GB free space on SSD
- first I did a backup for my huge database from HM1(just in case), more then 12Milion hands, not sure tho(20+ Giga PostgreSQL folder in size) .
-backup notes, and hud
-exported manually 300K hands I did play

- deleted HM1 and HM2 ( now I have 25 GB in free space )
-I import my own 300K hands
-I import ~ 5Milion hands it takes up close to 10GB in space.
- I try to import notes from my saved backup notes I had in HM1 more then 3000 player notes( I take allot of notes!) it appears that HM2 does not recognize a note file from HM1 :(
-I purge the hands from HM except my own, to free up some space(bad Idea!) I didn`t get free space and later I found out that when I purge hands I loose the stats on all the player( worst thing by far for HM2 :eek:), anyway this rise a question if I vacuum in in PostgreSQL like in HM1 can I get free space???

-another problems I encounter with HM2:

-I have no hud In replayer even if I did check the "show stats in replayer option",
-when I sit on a table I have absolutely no stats for any of the players there even if it should appear from my oun 300K hands that I did not delete.

ok so here are my main Questions:

-how to import allot of hands in HM2 and still have free space on my SSD
-is it Synk an option for this?
-Is it buying another SSD only for HM2 my only option?
-how do I get my saved notes from my HM1 to work on HM2(this is really important for me)
-how do I make the hud to appear in replayer

Hope you can help me with all this, and sorry for my bad english.
cheers!

[udbrky]

Out of HM1, HM2, PT3, HM2 has by far the smallest DB's. You can use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller:

Best practices for NTFS compression in Windows (http://support.microsoft.com/kb/251186)

You can put your postgres data folder and the HM2 database parent folder on a different drive.

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise, many of which are yet to come. If you don't want the space in your Roaming folder due to C: file space or something like that, we do give you the option of storing this data anywhere

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB

So with a 10 million hand database you need as SSD of at least 60 GB (Windows) + 100 GB = 160 GB.
We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

You can also run tree size free to locate wastes of space:

TreeSize Free - Quickly Scan Directory Sizes and Find Space Hogs (http://www.jam-software.com/treesize_free/)

---------------------------------------------------------------------

You can import notes in database console - import - from 1.0 - choose no hands and just notes

If your SSD is small, adding a second one can work. You can also put the postgres\data\base folder and HM2 db parent folder on a different drive - the speed decrease is not that much.

Are you doing a large import when playing - that will prevent the HUD from showing.

Otherwise, we need the holdemmanager.config and log.txt files from

Where is:
My log file
7/Vista: C:\Users\{username}\AppData\Roaming\HoldemManager\
Showing hidden files and sytem files and folders: How to show hidden files in Windows 7 (http://www.bleepingcomputer.com/tutorials/tutorial151.html)
XP: C:\Documents and Settings\User_name\Application Data\HoldemManager
Showing hidden files and sytem files and folders: Microsoft Corporation (http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_fcab_show_file_extensions.mspx?mfr=true)
to see what is going on.

[marius]

ty sir for you patience but after i did uninstall HM1 and HM2 again, I try to install PostgreSQL to a different drive, and even if I deleted the old PostgreSQL from my Programs automatically and deleted all the folders left from Program Files manually, when I try to install HM1 first on fresh, it keeps installing PosgresQL on the C: drive, because the installer says it has found a root or something in that drive :(

In FAQ I found this link:http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition but I got stuck there, and I cant do it.


I have to install both again HM1 and HM2 to keep my notes because HM2 it is not recognizing notes backup from HM1

Is there an easier way to install PostgreSQL to another drive from the beginning??

ty

[DogNamedBluff]

Is there an easier way to install PostgreSQL to another drive from the beginning??
You will need to manually install PostgreSQL separate from HM2. Here is a link for info on this: PostgreSQL Installer (http://pginstaller.projects.postgresql.org/)

[marius]

You will need to manually install PostgreSQL separate from HM2. Here is a link for info on this: PostgreSQL Installer (http://pginstaller.projects.postgresql.org/)

didn`t work, my backup was with postgreSQL 8.4. and your link was for older version 8.3.

this is an excelent post for what I need : http://forums.holdemmanager.com/manager-general/12925-postgresql-8-4-final-release-8-4-0-1-a.html

[udbrky]

The combo installer will install to that directory.

To place it elsewhere you need to install a standalone postgres like in that link.

You also need to delete the postgres user after uninstalling postgres.

Open the command prompt as administrator. It is in Start - accessories.

Type:

net user postgres /del

hit enter

Restart your computer.

Now install the postgres file and then install HM2.

[marius]

-can notes be imported and stored from HM1 to HM2 even if I dont import the hands to? presuming that in the future i will will play most of the player I had notes on HM1.

-an external HDD can be an solid option for a huge database, PostgreSQL & HM2? and if it is, do you have any recommendation?

[DogNamedBluff]

-can notes be imported and stored from HM1 to HM2 even if I dont import the hands to? presuming that in the future i will will play most of the player I had notes on HM1.
You need the hands to be able to import the notes and store them in HM2.


-an external HDD can be an solid option for a huge database, PostgreSQL & HM2? and if it is, do you have any recommendation?
i have a Seagate Expansion that i like a lot, very portable - it's like wallet size (slightly longer). Here is a link to a solid Seagate http://www.microcenter.com/single_product_results.phtml?product_id=0373123

[marius]

after almost a year I had to uninstall HM2 from computer but I am having the same problem like last year, I can`t Install PostgreSQL to other partition then C:

this are the step that I have done:

-uninstall HM2 and PostgreSQL
-deleted PostgreSQL file from C:
-deleted PSQLINSTALL file from Program Files(x86)
-deleted the postgres user using comand: net user postgres /del
-restart
-Install PostgreSQL from HM download page to H: partition, (at list this is my intention because PostgreSQL is getting install again in C: somehow:eek:)

Please tell me what am I doing wrong.

[DogNamedBluff]

Have you tried the steps in this FAQ? - http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition

[marius]

I did try that but is not working because there is another version of PostgreSQL- 8.3 , and that link is for moving a database to another drive partition and it is require some advance programing skill that I don`t poses, and beside that I don`t whant all that, I just want to install a fresh HM2 to other partition then C:

If you have anything else please help me.

[Patvs]

To install PostgreSQL to another partition:
if you use the manual installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org), it will always detect the old installation on C:, and therefore it won't give you the opportunity to choose a new install folder.

So solve this, either
-1 completely uninstall PostgreSQL (use a program such a REVO UNINSTALLER, the free version) so it also deletes ALL the registry keys that link to the C:/ install folder... or manually delete those registry keys.
-2 install a different version of PostgreSQL, for example if you run the PostgreSQL 9.0 installer for the first time, it will give you the option to choose an install folder.

(-3) use the FAQ: http://faq.holdemmanager.com/questions/368/MoveDatabaseToAnotherHardDriveOrPartition to change the location of the PostgreSQL/data folder in the system's registry.