Watch this video for step by step instructions.

Overview:

• Steps to Solve PostgreSQL Connection Problems
• PostgreSQL Won't Install

Steps to Solve PostgreSQL Connection Problems

• All steps are completely covered in the attached video.  
• Anytime HM2 opens when following these instructions =  PostgreSQL connection is fixed and you can stop troubleshooting the problem.

1. Make sure windows is up to date by manually checking for Windows updates.  (Video: 00:28)
2. Make sure Microsoft.NET is up to date.  If you did step 1, .NET should be up to date.  (Video: 00:28)
3. Check to make sure Window Services are started (Win7 & Vista Only) (Video: 1:28)
   
   1. Services can be started via control panel > administrative tools > services. We want to make sure "Secondary Logon" and "PostgreSQL" services are started.  
4. Test your PostgreSQL connection by starting HM2.  (Video 2:30)
   
   1. In HM2's PostgreSQL connection wizard, click the "Start Service" button.  If that fails, click the "Reset Password" button.
5. Delete Postmaster.pid file: C:\postgreSQL\data  or  C:\Program Files\postgresql\8.x\data\postmaster.pid  The file might not be there, DONT DELETE ANY FILES OTHER THAN POSTMASTER.PID (Video: 4:55)
6. Run HM.exe files as Administrator.  (Video: 7:00)
   
   1. HoldemManager.exe
   2. HudFuncsApp.exe
7. Turn off UAC.  UAC is Windows User Account Control.  (Video: 7:30)
8. Test your PostgreSQL connection by starting HM2.
9. Completely uninstall your Antivirus & Firewall software.  Don't ignore this, you can always reinstall them later.  (Video: 8:24)
10. Turn off Windows Defender.  (Video: 10:30)
11. Test your PostgreSQL connection by starting HM2.

Postgres Won't Install?

Try one of these standalone PostgreSQL versions:

1. PostgreSQL Version 1
2. PostgreSQL Version 2

TECH TEAM: CHECK BELOW FOR EDITS 2/16/2012

1. Windows classic view: Go to Start / Control Panel / Administrative Tools / Services. The Services dialog will pop up. Non-classic view: Control Panel / System / Administrative Tools / Services.

2. Scroll to PostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on it and choose Start. If it starts and then stops or was already started, follow the steps below:

3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.

4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.

5. Select Local System Account and then click Apply then OK.

6. Restart your PC and see if you still get the error.

7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.

Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

In the window that appears, type the following and press enter:

net user postgres /delete