cant backup database
Hi
I go to database and backup everything to a location. Hit "start backup". It shows a progressbar for a few secs and then it says backup completed. But I cant find any backupfile anywhere. I even tried 2 different harddrives.
Whats wrong? Im trying to get my database to my laptop, maybe HM sync will do the same?
thx
Yes, you can use HM Sync to move your database to another PC.
Which version of PostgreSQL are you running? Have you made any changes to your computer lately? Did you turn off any windows services lately?
Please install this version: http://www.holdemmanager.com/downloa...er_2_Setup.exe
Please make sure you are installing on an administrator account and running as an administrator.
Please turn off UAC.
You'll need to add holdemmanager.exe, hudfuncapps.exe, postgres and pg_ctl to the exceptions list in your firewall and antivirus.
Make sure that windows is fully updated. Keep checking for updates until it says twice five minutes apart that there are no more updates available.
You need to make sure that this folder
7/Vista: C:\Users\{username}\AppData\Roaming\HoldemManager\
Showing hidden files and sytem files and folders: http://www.bleepingcomputer.com/tuto...torial151.html
XP: C:\Documents and Settings\User_name\Application Data\HoldemManager
Showing hidden files and sytem files and folders: http://www.microsoft.com/resources/d....mspx?mfr=true
is not read only and that all permissions are set to full for your user name. The folder will continue showing read only after that, this is an issue in Windows.
If you continue to have problems, please reproduce the problem, describe exactly what you were doing and attach your log.txt file -
http://hm2faq.holdemmanager.com/ques...ger+Support%3F
HM SYnc seems to take like forever... Its very slow with big databases apparently.Originally Posted by DogNamedBluff
I have sorted all of those steps out but I think its the windows services part thats messing with me.. I think I will actually just reformat my computer cus Its been acting weird lately anyway.
Thx for the tips though, I'll just apply all that to my new laptop instead.
Another question off topic... Why does holdemmanager keep a copy of entire database in C:\Users\username\AppData\Roaming\HoldemManager\Da tabase
I have dropped the database in postgres. I expected it to delete the database in this folder as well, many ppl might forget about this folder and thye have bunch of old databases eating space on their small SSD's.
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
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
Im sorry if Im misunderstanding because Im tired, english isnt my native language and Im tired :O
But, HM2 would need: psql database folder for database, HM archive folder for handhistory files, and the folder we are talking about for hm2's own database or whatever..
So this sounds like HM2 needs more HD space for the same database compared to HM1, right?
HM2 uses 3 folders:
Archive folder (for handhistories)
PostgreSQL database
Roaming/Database folder
The size of the PostgreSQL database folder + the Roaming/Database folder for every million hands is about 4.3 GB* with HM2.
For HM1, just the PostgreSQL database folder would be about 6.8 GB for 1 million hands.
(PT4 uses 13.6 GB in their PostgreSQL folder for 1 million hands)
*If you use NoteCaddy it will use more space.
So overall, despite this structure (storing data in two folders) it will only use 2/3 the size of a HM1 database... and stores 2-3 times MORE data.
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
thats great. thanks for the help.
oh btw, u should maybe inform ppl about this (maybe u did and I missed it) but many ppl open and close new databases frequently and dont know that a lot of dead gigabytes is sitting in that roaming folder. Since pgadmins "drop delete database" doesnt remove this folder
Hi there, how do I implement storage of this data in another location other than the default roaming folder on the C: drive?
Home tab--> Database--> create a new database, and you can select the location of this database folder.
Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.
If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here
Hello Patvs
I am trying to create a DB backup but it's not working.
I have a 16gb database and it lasts about 10min to finish the process then I get a message that the bkp is completed. However, the file is not created.
I notice my ssd is getting out of space while the bkp process is running. It starts with 39gb free. I also tried my second hd with 300gb free.
I am using the latest version of HM2.
Obs: If I choose to bkp only configs, it works but I need all my data base.
Posting Permissions
