PDA

View Full Version : Can't connect to database.



Setcho
08-04-2012, 05:15 AM
Hey,

My HM have stopped working and I get the error message "Failed to establish a connection to ‘127.0.0.1’"

I have tried pretty much all the steps from the FAQ below, but it still isn't working. I must have missed something, but I'm running out of things to try. Any ideas?

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

Patvs
08-04-2012, 05:40 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. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely



Install SQL 8.2 http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
to an unused port.

Setcho
08-04-2012, 06:31 PM
I tried all the steps you suggested already. I also tried your Combo-installer, but couldn't get it to work. I have PostgreSQL 8.4 installed right now, should I still go with 8.2?

Patvs
08-04-2012, 07:02 PM
To get 8.4 working again:
Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Check your hosts file. It should look like:
http://holdemmanager.net/forum/showthread.php?t=8182


If that doesn't resolve it, install SQL 8.2 which will always run.