PDA

View Full Version : Can't connect to postgre



overbet56
11-17-2009, 04:03 PM
I start up holdem manager, and gget an error that says the following error occured when trying to open the database failed to establish connection to 127.0.0.1 Then postgreSQL comes up and I click connect and get a connection to postgre could nto be made. Would you like to have HM attempt to start the service. I click yes, then i get holdem manager was unable to start the service blah blah blah.


I tried installing and reinstalling postgre and I'm still getting the same problem. My firewall is not blocking it either. So can anyone get me out of this tech problem.

fozzy71
11-17-2009, 04:54 PM
This is usually a firewall or windows update issue.

First try to reboot. If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the compatibility tab. Windows 7 you MUST set all the executables to always run as admin.

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) reinstall the same version of postgresql, using the same \data folder - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands.

overbet56
11-18-2009, 02:48 PM
How can I just totally remove holdem manager and postreSQL from my computer and just reinstall everything to get a fresh new database. I went though all of those steps and I'm still not getting it working for me.

MrThomasMoyes
11-18-2009, 03:58 PM
I had a bunch of problems getting HM and PostgreSQL to work, I managed it yesturday, everything worked, i imported all my hands etc, reviewed a bunch of hands, but Ive tried loading it today and its now doing exactly the same thing you're talking about. How can I just get this sorted, Ive uninstalled and reinstalled so many times, gone through all the steps etc my firewall isnt blocking it, ive got UAC off, its getting really annoying!

fozzy71
11-18-2009, 04:46 PM
How can I just totally remove holdem manager and postreSQL from my computer and just reinstall everything to get a fresh new database. I went though all of those steps and I'm still not getting it working for me.

You probably dont need to reinstall HM, just postgresql.

Reinstall SQL - http://forums.holdemmanager.com/showthread.php?t=20755

If you need to backup and reinstall HM for any reason:

http://www.holdemmanager.net/forum/showthread.php?t=20754

http://www.holdemmanager.net/forum/showthread.php?t=20816



I had a bunch of problems getting HM and PostgreSQL to work, I managed it yesturday, everything worked, i imported all my hands etc, reviewed a bunch of hands, but Ive tried loading it today and its now doing exactly the same thing you're talking about. How can I just get this sorted, Ive uninstalled and reinstalled so many times, gone through all the steps etc my firewall isnt blocking it, ive got UAC off, its getting really annoying!

Which firewall and anti-virus? It wont connect when you reinstall sql either?

*If that doesn't help, Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.com/downloads/TeamViewerQS.exe. Please let me know what time zone you are in and what time/days are convenient for you.