So like many of you, I've been pulling my hair out for days because I could not get a connection to my database. After hours upon hours of research and failed attempts, I finally figured out a method that has worked on both of my comps and a friend's comp as well. Hopefully it will work for you as well. This worked for me on an XP PC, an XP laptop, and Vista Basic PC. Without further ado:
1. Do the standard step of fixing your host file
Instructions can be found here.
2. Uninstall any antivrus, anti-spyware, and firewall programs you may have.
This includes disabling windows firewall and windows defender, although you cannot uninstall them.
3. Follow steps 1 through 6 in FAQ 171
When you get step 6, stop after you have uninstalled PostgreSQL. DO NOT REINSTALL IT YET.
4. Find your PostgreSQL Data directory on your computer.
By default, this should be at C:\Program Files\PostgreSQL\8.3\data or something similar. Make note of its exact location and the exact name of the folder. You will need this info later. Now you need to Rename this Folder to something like data_original.
5. Now do a clean install of PostgreSQL.
Make sure you install the proper version number. If you were using 8.2, make sure you install 8.2. If you were using 8.3, install 8.3. Follow the instructions in FAQ 176. In step 5 of that FAQ, make sure you set up the data directory to match the info you wrote down in step 4 of this guide. Once you have PostgreSQL installed, verify that HoldemManager can connect to this new, empty database. You don't need to create a HoldemManager database, just verify that you can get a connection.
6. Now you need to copy some files from your new data directory to your old one.
Go to your newly created data directory and copy the following files:
DO NOT COPY postmaster.pids
Go to your data_original folder and paste these files. They should already exist in that folder, so make sure you overwrite the exisiting ones. Also, delete the postmaster.pids file that should be in your data_original folder.
7. Uninstall PostgreSQL again.
After the uninstall has completed, go delete your data directory folder. Rename data_original so that it matches the name and location of the folder you just deleted.
8. Reinstall PostgreSQL using the steps in FAQ 177
9. Now Holdem Manager should be able to connect to your original database.
If you still can't connect, guess you're S.O.L.
10. Now reinstall and enable your firewalls, antiviruses, etc one by one.
After each one that you install or enable, make sure you test Holdem Manager to make sure it can still connect. If after installing or enabling something you can't connect to your database, then you have found the program that is most likely the cause of all this headache. Consult that programs support for ideas, or try another similar program.