PDA

View Full Version : Unable to Connect to Postgre



GoodFriday
05-05-2013, 08:18 PM
Today when I started HoldEm Manager I got the following error:

"The following error occured when trying to open the database. Failed to establish a connection to 127.0.0.1"

Then I hit OK and the PostgreSQL Database Control Panel comes up. After attempting to connect I get the following error from the control panel:

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

When I hit yes, I get the following error:

"Sorry, Holdem Manager was unable to start the service."

Then when I hit OK, I get the following message:

"Holdem Manager has started the service. Please try again."

This cycle goes on ad infinitum. Everything had been working fine until today. Would a System Restore to earlier have any merit? What can I do?


Thanks

udbrky
05-05-2013, 08:45 PM
- Please see these steps to fix postgresql connection issues:

http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+

- Please make sure that you have allowed postgres and pg_ctl in your firewall and antivirus exceptions. They are in postgres\bin.

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working.

See this guide for Windows Firewall:

http://hm2faq.holdemmanager.com/questions/1052/Windows+Firewall+%7B47%7D+Defender+Problems

Download the same version you are running from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) - do not use 9.1.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.