Failed to establish a connection to '127.0.0.1'

[airharm]

So I restarted my computer earlier and when I opened up HEM i got the following error:

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

I'm pretty sure this is a problem with postgresql and my computer, does this have something to do with firewall, antivirus scanner? Can somebody please link me to a thread that troubleshoots this problem?

Thanks.

[airharm]

I tried the following out..

"Go to start, all programs, PostgreSQL8.2 (or whatever you have) then configuration files, then edit pg_hba.conf

You will get a notepad looking screen at the bottom you will see this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5

what I want you to do is to make a new line underneath the data right above. Make it look like this

# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 127.0.0.1/62 md5

Basically you are adding a line that is the same except for the /62 at the end of the IP address. You can copy paste or type it in manually but use the same spacing (space bar)

Then go to file, save and you are done. Restart HM and it should work. "

and it still doesn't work, please help someone...

[airharm]

Alright, I read someother thread and someone said to uninstall postgresql and then reinstall it..

I did this and it still doesn't work, I also disabled windows firewall and uninstalled the only antivirus scanner I have...

HELPPPPP

[morny]

You need to restart the PostgreSQL service as it has stopped:

http://208.109.95.123/faq/afmviewfaq.aspx?faqid=34

Then if you get the stopped then started message when restarting the postgreSQL service try this http://208.109.95.123/faq/?f=164

[moby_duck]

I had the same problem, followed all steps recomended, and now this message appears when I start Holdem Manager: The following error ocurred when trying to open the database: FATAL: 3D000: Database "HoldemManager" does not exist

[morny]

Never seen that before, can you try uninstalling and reinstalling postgreSQL and reboot after unistalling and see if it still shows up. If it continues email me morny@holdemmanager.net to arrange a www.teamviewer.com session

[airharm]

You need to restart the PostgreSQL service as it has stopped:

http://208.109.95.123/faq/afmviewfaq.aspx?faqid=34

Then if you get the stopped then started message when restarting the postgreSQL service try this http://208.109.95.123/faq/?f=164

this does not work, it will not start, and i have windows firewall deactivated, and currently no anti-virus on my computer at all...

need more feedback.

[airharm]

Well I got it to work for now.. I did two things..

1.) disabled wscntfy.exe (it should be running in task manager or as a system process)

"Microsoft's Security Center, more of an annoyance than anything. To get rid of it, go to Control Panel, Adminstrative Services, Services - then find Security Center and change its startup atttributes to Disabled from Automatic.

I did the above and then I also just stopped the security service thing completely

2.) Port forwarded 5432 in my router settings

One of these two things allowed me to restart postgresql service and got it to work for now...

Like I said though, I was having this problem with absolutely no firewall (I even disabled windows firewall) or antivirus scanner (unless my router has some kind of built in firewall or something)

Hope this helps! Leave feedback if you were having this problem also (I'll be back if I get this problem again in the future~ to troubleshoot it some more)