I'd like to delete these 1.11TB of files...

[TimM846]

I have a fast computer that doesn't need upgrading, but because I'm such a noob, I've managed to make it slow over the past year or so. I'm taking steps to fix it and I'll be going step by step through the HM2 performance tips thread.

The first step I'm taking is deleting files I don't need. I've had a few different DBs and my current one is a couple months old. This particular folder is massive:

D:\PostgreSQL\data\base\21892132

(1.11TB; the entire base folder is 1.15TB)

Nothing in this folder has been modified since April 19th, long before I created my new DB. But I read a post in another thread saying I shouldn't touch this folder because it will corrupt my DB. I'm sure I don't need all of these files, so what do I need to do to get rid of them?

[Patvs]

HM2 stores your "data" in two locations:

-1. C:\Users\{username}\AppData\Roaming\HoldemManager\ Database
-2. and the PostgreSQL database in D:\PostgreSQL\data\base



In -1 you can delete all the folders of old databases you no longer use.
In -2: Don't delete any files/folders in this folder. Instead open pgadminIII and delete your old databases.
This will delete all the corresponding files in the PostgreSQL database folder.

[TimM846]

Thanks for the reply. Now I just need to figure out how to delete my old DBs with pgAdmin III. I don't see any options for that when I open pgAdmin III. I think I moved a past database or two from my SSD to my regular hard drive, so maybe that's why they're not showing up. Or maybe I just don't know where I'm supposed to be looking.

I see this when I load pgAdmin III:

158207

[_Loki_]

...Now I just need to figure out how to delete my old DBs [...] don't know where I'm supposed to be looking Look at the last three pictures in the link below:- You double click on the little red crosses to open the trees in the left pane. The password prompt will popup. Enter postgrespass as a password - if that fails try postgres

Install PostgreSQL
(http://www.postgresqltutorial.com/install-postgresql/)

[TimM846]

Look at the last three pictures in the link below:- You double click on the little red crosses to open the trees in the left pane. The password prompt will popup. Enter postgrespass as a password - if that fails try postgres

Install PostgreSQL
(http://www.postgresqltutorial.com/install-postgresql/)

lol @ how dumb I am. thanks.

[TimM846]

I deleted the only old database it let me delete, then restarted, but the data folder is still the same size. Can't I just export my HHs and then delete EVERYTHING and start over?

[udbrky]

If you want to delete everything, this is going to be the easiest step. You have 2 Postgres installations. You only need 1 and there are probably files in the other installation that you were not deleting.

In HM2, delete all of the databases. You have to create a new empty one first.

This should clear all of your database and files.

You should get rid of Postgres completely and start clean.

It appears there might be an issue with PostgreSQL and reinstalling it should help resolve this.

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser). This is important because it will install critical updates that affect PostgreSQL and maybe related to the issues you are seeing.

Please note that reinstalling PostgreSQL will mean losing all your old databases. Your hand histories are located in c:\hm2archive and/or c:\hmarchive.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Delete the \PostgreSQL\install#\data folder that is left behind.

3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

4) Restart your PC

5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_2_Setup.exe

Start HM2 again and create a New Database.

[LeBronas]

HM2 stores your "data" in two locations:

-1. C:\Users\{username}\AppData\Roaming\HoldemManager\ Database
-2. and the PostgreSQL database in D:\PostgreSQL\data\base



In -1 you can delete all the folders of old databases you no longer use.
In -2: Don't delete any files/folders in this folder. Instead open pgadminIII and delete your old databases.
This will delete all the corresponding files in the PostgreSQL database folder.

I have done the worst - deleted data in D:\PostgreSQL\data\base . I saved it before in other place and did copy it back, but HM (postgresql) is not working.
What should I do and how can I fix this problem now? :-|

[fozzy71]

I have done the worst - deleted data in D:\PostgreSQL\data\base . I saved it before in other place and did copy it back, but HM (postgresql) is not working.
What should I do and how can I fix this problem now? :-|

You may not be able to save it but you can try the following steps and cross your fingers:

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
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 - http://hm2faq.holdemmanager.com/questions/1591/Reinstall+PostgreSQL+8.4+while+preserving+database
http://www.holdemmanager.com/downloads/postgres84

[LeBronas]

You may not be able to save it but you can try the following steps and cross your fingers:

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
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 - http://hm2faq.holdemmanager.com/questions/1591/Reinstall+PostgreSQL+8.4+while+preserving+database
http://www.holdemmanager.com/downloads/postgres84


Wil I loose all my data (hands and notes) by doing this?

[fozzy71]

Wil I loose all my data (hands and notes) by doing this?

The name of that article is 'REINSTALL POSTGRESQL 8.4 WHILE PRESERVING DATABASE', so no you will not lose that stuff if it is successful but there is basically a 50/50 chance it will work. If it works your old database and all the notes would be restored. If it does not work there is nothing else you can do. This is one of many reasons why you should make regular backups and store them on a different cloud/drive.

[LeBronas]

You may not be able to save it but you can try the following steps and cross your fingers:

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
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 - http://hm2faq.holdemmanager.com/questions/1591/Reinstall+PostgreSQL+8.4+while+preserving+database
http://www.holdemmanager.com/downloads/postgres84

So I did this and HM is not working with old database (not connecting to server or smth like that).
It's working with fresh postgresql and no database.

Is there any way to fix my old database?

[fozzy71]

So I did this and HM is not working with old database (not connecting to server or smth like that).
It's working with fresh postgresql and no database.

Is there any way to fix my old database?

If those steps didn't work there is nothing more we can do. You will have to recreate it manually by importing the hands again. This is why regular backups are a good idea. If your database becomes corrupt or you have any other issues like a hardware failure you can restore a backup of your hands/notes and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. You would only end up missing your manually created hand/player notes that were created after your last backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F