PDA

View Full Version : can't connect to sql server (and none of the tips in the faq work)!



iDonk
01-10-2010, 03:22 PM
It just stopped working from one day to the next, I get the error message "failed to establish a connection with 127.0.0.1".

Upgrading to the newest HEM beta didn't work.
Re-installing Postgress didn't work

What can I do?
-Ben

fozzy71
01-10-2010, 03:56 PM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

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

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

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

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

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 using these instructions - http://forums.holdemmanager.com/showthread.php?t=20755

iDonk
01-10-2010, 08:08 PM
thanks. I had already done a lot in that thread, but not all. Now it works!