PDA

View Full Version : Failed to establish a connection to 127.0.0.1



koalauser
08-27-2011, 10:12 AM
Hi,
I installed HEM, and all worked fine. I also get some old hands in thru restore function.
But when I restart my computer i get the postres error : The following error occurred when trying to open the database: Failed to establish a connection to 127.0.0.1 . I found a FAQ about it. But I am not running any antivirus or spyware remover. I feel like there will be some very simple solution. I am running win 7. Thank you for your help.

koalauser
08-27-2011, 11:53 AM
wrong forum sry

Patvs
08-28-2011, 05:30 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
Try the manual installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
Try PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip) to port 5433 if 8.4 doesn't run

koalauser
08-28-2011, 10:53 PM
Thank you very much, it works but i have to do it every time i restart computer :/. But it works witch is great.

netsrak
08-29-2011, 03:42 AM
You can try this:
Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"

koalauser
08-29-2011, 04:16 PM
No did not work, still have to stop and start postgres manually every time i restart computer. But ty.

Patvs
08-30-2011, 12:26 AM
Add exceptions to the windows firewall for pg_ctl.exe even if the firewall is turned off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.

pg_ctl.exe is in the PostgreSQL/8.4/bin folder

koalauser
08-30-2011, 01:19 AM
Already did that but still dont work :). Dont have any other firewall or antivirus.

netsrak
08-30-2011, 03:55 AM
I'm afraid we have no other solution other than a complete new installation of postgresql.