Have I done something wrong?

[walofs]

Hi,
My database was working fine last week. However, when I do a report (any report) it only shows data from the 26th February, i.e. 2 days ago.
I have tried vacuuming and re-indexing the database without it changing anything.
The size of the database is 91GB. It is on a 225GB SSD with only a very small amount of free space. I also have a 1TB HDD with plenty of free space.

Could it be the lack of space that is causing the problem?
Is there any way that I could reduce the size of my database as I really only need a few weeks of data for NoteCaddy and HEM2?

Or is it better to move it to my HDD? If so how do I do it?

Thanks for your time.

[udbrky]

You need to always have at least 20% free space on the drive.

Please see this FAQ to move your database to another drive. Please note this is an advanced article and we do not provide support for this method if you encounter issues but at the request of users we decided to make a FAQ for those who felt confident enough to try this method.

Hold'Em Manager 2 FAQs - Poker Software :: Move Database to Another Hard Drive or Partition (http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition)

Try fixing the database.

Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon) (http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance)

If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands (http://hm2faq.holdemmanager.com/questions/3091/How+to+create+a+new+database+and+import+previously +played+hands)

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work? (http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F)

If you continue to have problems, please reproduce the problem and zip/attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing - Hold'Em Manager 2 FAQs - Poker Software :: How Do I Send a Log File to Holdem Manager Support? (http://hm2faq.holdemmanager.com/questions/1921/How+Do+I+Send+a+Log+File+to+Holdem+Manager+Support %3F)

Please zip and email the requested files via the 'Contact Support' link here - https://support.holdemmanager.com/ - and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

When sending any files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then 'copy public link' and paste the download link directly into the support ticket and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

[walofs]

Hi,
I have almost finished moving the database to a new drive. There are 2 things I'm not clear about and they are both to do with ""change the path to the Parent in Settings table of database"":
1. I have 2 databases in pgadmin: HoldemManager2 and postgres. I take it that I use "HoldemManager2"?

2. ""then select the value line (for DatabaseParentFolder) and you can edit the line to the 'f:\newParent' location you assigned previously"". The value line in my case is C:\Users\nestgc\AppData\Roaming\HoldemManager\Data base
Do I just purely change this to "f:newParent" and miss out any other folders?

Cheers

[walofs]

Thanks for your help.
I really need to play poker and unfortunately cannot spend any more time on moving the database as I really need my HUD, along with reports. Can you please tell me how to do a clean install of HEM2 and postgres, setting them both up on a different drive i.e. not on C:\

Hopefully I will be able to import from HM2 archive but if not I'll just start from scratch.

[udbrky]

Do NOT touch the postgres information.

Yes, change to f:\newparent. The steps in the FAQ need to be followed perfectly.

You can also create a new database, choosing the new parent folder location on the other drive. Then import from c:\hm2archive. If you backed up the rest of the DB, restore it.

You could put the postgres database and reinstall Postgres too.

Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work? (http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F)

If you cannot access the database in HM2 then you can backup your database using this method: Hold'Em Manager 2 FAQs - Poker Software :: How does Backup or Restore via PostgreSQL work? (Advanced Method) (http://hm2faq.holdemmanager.com/questions/952/How+does+Backup+or+Restore+via+PostgreSQL+work%3F+ %28Advanced+Method%29) but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

net user postgres /delete

3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

4) Reboot your PC

5) Install the same version of PostgreSQL as your previous database using these instructions - Hold'Em Manager 2 FAQs - Poker Software :: Reinstall PostgreSQL 8.4 while preserving database (http://hm2faq.holdemmanager.com/questions/1591/Reinstall+PostgreSQL+8.4+while+preserving+database )
http://www.holdemmanager.com/downloads/postgres84

Then, the old ones can be deleted.

[walofs]

Hi,
Unfortunately it didn't work moving the database to e:\newParent. I therefore setup a new database DB3 into the same folder - this worked fine.

My old database, DB2, is now partially setup in e:\newParent - can I just simply delete it from this folder?

I'm using PostgreSQL version 9.3 and DB2 is also in C:\Program Files\PostgreSQL\9.3\data\base. Can I just delete it using pgAmin 111 ?

Is it now worth uninstalling postgreSQL and trying to reinstall it on my E drive or not worth the trouble?

One other question: my previous imported hands were all in C:\Users\nestgc\AppData\Roaming\HoldemManager\Data base\DB2\Players\2. Can I delete thes ?

I imported a lot of hands from over a week ago to my new database (DB3) but it seems that only hands from the last 2 days are in E:\newParent\DB3\Players\2 How do I check if everything is pointing to the correct place?

Thanks for your patience.

[udbrky]

If you delete it in HM2, that will delete both.

When you import, hand info will be in both the parent folder and in the postgresinstall\data\base folder.

[walofs]

Hi again Chris,
I've just been checking files in my folders and found 5 corrupt files in C:\Users\nestgc\AppData\Roaming\HoldemManager. They have various dates from 31st January (2016) and are named similar to "HoldemManager.config26437.1543966.corrupt".

What do you suggest I do next?
cheers,

[udbrky]

You can delete any corrupt files.

[walofs]

Thank you.