big problems after canceled update

[MassaTheChamp]

Hi!

Today i tried to install the new version 1.12 but because HM said it would take very long, i have a huge database, i task-manager killed the HM.
After that i installed 1.11.06g again (undo all the win7 updates) and started playing, but there was no HUD, so i guess i messed up everything. Then i moved on another PC to play (i wish i would do that in the first place) and installed 1.11.07 with windows update fix on the primary PC.
I had to do that twice because i had no space left on C drive. And after the HM did his work i got the attached messages (another one after i clicked OK). And if i start HM again i get the "large database update" message again.

What do you reccomend that i do? Uninstall everything, make new database and install which version? And then reimport all the hands? Can i install windows updates?
It would be really cool if you helped me out today so i can start playing again tommorow.

Thanx

edit: What do you recommend i do with my database?
I have it on C drive, which is Kingston 128GB SSD, but the databse is 105GB in size. Should i have it on D drive after a reinstall (where i can delete a bunch of stuff and have enough space)? But it won't work as good as on SSD correct? Please advise what would be best to do in my situation.

[Patvs]

Do you have 1 massive database (10+ million hands?)
Or several smaller databases?

Any chance you can free up 5 more GB of freespace on C:/.
Run crapcleaner, delete restore points, uninstall a game, etc?

So the database update can finish.


---


If you can't, read: http://faq.holdemmanager.com/questio...iveOrPartition

and try to move everything to D..

or

Run pgadminIII: backup a database (that can fit on the 4.5 GB free diskspace).
Move the backup file to D
delete the database in pgadminIII
That should give you enough space to perform the database update on the other database (assuming you have more than 1)


or


Run dbcontrolpanel.exe, create a new database

----



The database update needs a lot of space. (you won't get that space back, it's creating dozens of new tables for the new HUD stats)

You could also consider to stay at 1.11.06g, then purge ALL old hands (<2009) The problem with only 4.5 GB of diskspace is, it's probably not enough to perform a VACUUM in pgadminIII.

[MassaTheChamp]

I had 2 databases, not sure why/when i made 2. Now i deleted one and i have 15GB of space left. I am currently adding all of my gf's hands to my PC, so now i'll have even more hands, not that much, just for 5 months. Before that i had just under 2 million hands (from 2009-) so not even close to 10 million - should i have more space left? I disabled logging long time ago and don't have any log files.
After it's done should i install the 1.17 version first and then install those windows updates?
Do i purge hands (from 2009) after i update HM to 1.17 or before?
And then do the vacuum? Is 15GB enough space for this?

Does it increase performance if i move HMArchive from D to C (SSD)? This folder is 2.4 GB in size.

Thanx for the help

[Patvs]

2 million hands should only take up 20 GB of diskspace.
If yours take up 100 GB, you probably have some sort of log files in another folder you can delete.

Check which of these folders on your computer is 60+ GB?
-C:/Users/
-C:/Program Files/PostgreSQL
-C:/Program Files/RVG Software

It doesn't matter if you install the Windows Security Updates or 1.11.07 -http://www.holdemmanager.com/Downloads/HmUpdate.exe - first.

15 GB should be enough for a vacuum is the database is only 20-35 GB.
15 GB should also be enough for the database update to now finish without running out of diskspace.

Moving C:/HMArchive to the SSD will have no effect.... unless you often plan to reimport all your handshistories. If you perform mass imports / batch-imports, it will be faster for the import speeds if the handhistories are also on the SSD. You can move them back to D:/ after they're imported.

[MassaTheChamp]

-C:/Users/ 21.2GB
-C:/Program Files/PostgreSQL 40.2GB
-C:/Program Files/RVG Software 270MB

But 105GB for PosgreSQL says in the programs and features

edit: my mistake, i have 2 mill. hands just from my nickname - if i go to Tourney - Results - Players Change and enter my nickname, so i probably have alot more hands...

[Patvs]

C:/Users/ ---> 20 GB is really large.
You must have at least 10 GB of files in there you don't need.
Maybe a lot of files in your downloads or desktop folder, you can move to D:/

If you have 10+ GB in the Users/%username%/AppData/Roaming/Local or
Users/%username%/AppData/Roaming/Local/Temp folder you can also delete all the large files.

[MassaTheChamp]

I had 6GB of files in the temp folder, other folders were low on size like 300MB. I also had 7GB of camtasia recordings + 4GB of other stuff in the documents folder, which i moved to D.
So now i have 31GB of free space left

Do i still need to purge hands (that means that i wouldnt be able to replay or see the hands, but they would be used in stats or is that just deleting of hands?), how much space would be saved approximately if i just purged the hands of 2009? I'll just do the whole optimization for now.

[Patvs]

No need to purge the hands.
Purging will delete the largest index (containing the handhistories), but there will still be 87 indexes left so it won't influence your performance/save you a lot of diskspace since you already have a SSD>

[MassaTheChamp]

Damn, something went wrong, i got the error when trying to optimize the database. Reason?
I'll try to do it manually.

[Patvs]

Use pgadminIII instead.