new error for me: Failed to establish a connection to '127.0.0.1'.

[shuman]

Hello. I cannot open my HEM. I had version 1.06, and thinking this might be the problem, I updated to the most recent version: 1.11. I still cannot open HEM and get the following error:

The following error occurred when trying to open the database: Failed to establish a connection to '127.0.0.1'.

Then, after I click "OK" the following screen appears:
(I've attached a snapshot jpg)

I click "Connect" and get the following popup:

DB ControlPanel
A connection to PostgreSQL could not be made. Would you like to have Holdem Manager attempt to start the service?

I click "Yes" and get the following popup:

DB ControlPanel
Sorry, Holdem Manager was unable to start the service

I click "OK" and get the following popup:

DB ControlPanel
Holdem Manager has started the service. Please try again.

I click "OK" and am back at the same Database Control Panel screen as above that I've attached to this post as a jpg.

I have Windows 7 Home Premium 64-bit, and I've already read through the FAQs pertaining to this error. I did all of the following months ago:

--Disable UAC
--Run all applicable .exe files as Administrator
--Add all applicable .exe files the to Windows Firewall as exceptions/allowable
--Disable Windows Defender
--Add all applicable .exe files the to my AVG Free 9.0 antivirus

I've also gone into Control Panel > System and Security > Administrative Tools > Services > right click on PosgreSQl Server 8.4 > "Start"

I get the following popup error:

Services
Windows could not start the PostgreSQL Server 8.4 service on Local Computer.

Error 3: the system cannot find the path specified.

So, then I go into Control Panel > System and Security > Administrative Tools > Services > right click on PosgreSQl Server 8.4 > "Properties" > Log On tab

I was going to copy and paste the username: .\postgres, into Notepad and check "Local System account" instead of "This account" and try and reboot my computer, but I am not able to copy and paste the hidden Password, nor do I even know what it is (it's 15 characters in length).

The only other tip I read that I have NOT tried yet is un-installing/re-installing PostgresSQL. I did not want to do this and risk losing all of my saved hands in my database before you could advise me.

I was able to open HEM and auto-import about 20 hours ago, but then I had a rare problem with my computer freezing. This was the second time this particular freezing problem occurred with my SONY VAIO laptop (Intel Core 2 Duo CPU P7350 @ 2.00 GHz 2.00 GHz, 4.00 GB RAM). I was multi-tabling No Limit Holdem cash games on Full Tilt when the computer froze and there was a "crackling"/"frying" sound coming from the computer speakers. I removed the battery back, and then re-installed it and rebooted the computer after letting it sit for an hour. Then, I went into my VAIO Care and ran tests on the hard drive, One Click Care, and System TuneUp to make sure everything was ok. And now I cannot open HEM, so maybe something got messed up.

Could you please advise me what to do?

I un-installed and re-installed only HEM (not PostgreSQL) after copying my Config folder to my Desktop, but this has not fixed the problem.

Do you think I should un-install/re-install PostgreSQL, and if so, beforehand do I need to save certain file(s) to a memory stick so my saved data/hands/notes do not get deleted?

But, since I cannot open HEM, am I even able to Export all of my hands to a memory stick? I have copy and pasted the files: C: > HMarchive Full Tilt Poker (745 MB), and C: > HMarchive PokerStars (64 MB) to a flash drive. Do these 2 files contain all of my saved hands for HEM?

Does my HMarchive PokerStars file also contain my saved HEM notes?

Or, do you think my database has somehow gotten corrupted and I've actually lost all of my saved hands and HEM notes, or just the notes?

Please let me know what you think I should try next to fix this big problem.

Thank you.

[netsrak]

1. You have a postgresql problem. Nothing you can do in HM do fix it.
2. To backup the data you should copy the hmarchive as you did but it doesn't contain notes, stats etc. only the hands. You should save the Postgresql data folder too.
3. From the message you get when trying to start the postgresql service i think your computer crash damaged your postgresql installation. I think you should try a reinstall of postgresql connecting to your old data folder:
FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database

If you can't figure it out: Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer session.

[shuman]

Thanks. So, I should also copy the PostgreSQL > 8.4 > data folder to my memory stick? Should I copy the entire 8.4 folder, or do I only need the data folder?

Also, you say "the hmarchive doesn't contain notes, stats etc. only the hands." So does this mean I've completely lost the HM notes I've taken and all the stats I had on all my other players?

Thanks.

[netsrak]

1. Yes, copy the data folder.

2. If you can't restore the data folder all your notes etc are lost. Thats why you should backup a database regularly.

[shuman]

Thanks. I guess I'm still not clear as to all of the folders/files for which I should make backup copies. I keep a copy of my entire Holdem Manager folder on my desktop, but that's it for HEM and PostgreSQL.

I'll keep a copy of the PostgreSQL data folder now too.

Do you know of any other files/folders I should make regular copies of, or a link to a recommended list?

Thanks a lot.

[shuman]

After having already un-installed and re-installed HEM by itself, I tried to do the same with PostgreSQL via the following link you provided me in a previous post:

3. From the message you get when trying to start the postgresql service i think your computer crash damaged your postgresql installation. I think you should try a reinstall of postgresql connecting to your old data folder:
FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database

After the re-installation was complete, I tried to open HEM but I got the same error again--only this time I kept being taken to a popup asking me for another database username and I wasn't sure what to do. I also read another FAQ saying that the PostgreSQL re-installation should be the same version number as my old one in order for my old hands and notes to be able to work. So, considering the above link was for version 8.3 and my old version was 8.4, and that I was getting the same error popup again, I decided to un-install both PostgreSQL 8.3 and HEM.

I then re-installed the "Combo" option for HEM and PostgreSQL, and the version happened to be 8.4, which I was looking for. I was also able to Import old hands from my HMarchive Full Tilt Poker folder.

Other questions I have are:
1) Should I try to copy-paste and replace my saved Desktop PostgreSQL data folder into the new 8.4 folder to try and recover my saved HEM notes? Or, is there a specific file in my saved Desktop old data folder that contains my HEM notes that I can "Import" into my re-installed HEM?

2) For my old database, I had created the archive folders: HMarchive Full Tilt Poker and HMarchive PokerStars. Now, in HEM > Options > Configure Auto Import Folders when I click "Edit" under each of my Full Till and PokerStars locations the Archive Folder is set as HMArchive. Should I keep this new default archive folder the same for both sites, or can I use the above old specific archive name folders I created again?

Thank you.

[netsrak]

1) don't copy the postgresql data folder into a running installation. This will kill your new database

2) You can use whatever archive folder you like. Having them in different folders per site is a good idea.

For backing up data and configuration: FAQ - Hold'em Manager Poker Tracking Software :: Reinstalling on a new PC - Backup Tips

[shuman]

I think I damaged my postgresql installation again like I did a while ago above, so I uninstalled/reinstalled postgresql and holdemmanager 1.11.05 using the Combo install option.

I then used the newer "Backup & Restore" option under HEM > File from an old backup file I saved to my desktop.

Before uninstalling my old postgresql and holdemmanager, I also saved to my desktop copies of the folders: Holdem Manager, Config, and data.

>>Should I now copy/paste all of the files in my desktop saved old Config and data folders into the new folders of the same names in my C: > Program Files (x86) > Holdem Manager and PosgreSQL > 8.4 folders?

You warned me the about the following above in the past, so I want to be sure before I copy/paste anything else:

1) don't copy the postgresql data folder into a running installation. This will kill your new database

Thanks.

[morny]

You should copy the config folder to C:/Program Files/RVGSoftware/HoldemManager if you want to recover your old hud settings, but you dont need to copy anything from the other two folders, that data folder is your old PostgreSQL data files so as mentioned copying that to the data folder again would corrupt your database

[morning storm]

curious if you were able to remedy this problem in this end?

i have exactly the same problem and am pulling my hair out over this

anything that helped or worked wouuld be greatly appreciated, thanks