HM suddenly stopped working :(

[statsmonster]

I restatrted my computer and HM won't start up :( The following error occured when trying to open the database: Failed to establish a connection to '127.0.0.1'. After i press ok the Database Control Panel pops up i click connect and DB Control Panel window pops up saying connection to PostgreSQL could not be made. I choose the option to have HM attempt to start the service and and error comes up "HM was unable to start the service". Any help would be much appreciated. thanks

[statsmonster]

Fix for PostgreSQL cannot start error 127.0.0.1 did not work for me. i opened file using notepad and it read exactly as you recomended we type it.

[netsrak]

Please check our FAQ:
FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)
FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall) (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)

[statsmonster]

I followed each of the steps in both links and i still have the same error messages popping up. Any other ideas? Thank you

[netsrak]

Is your postgresql service running?
Did you install any security software?
Are you using windows defender - if yes please uninstall.

[statsmonster]

My postgreSQL service appears not to be running. when i start service a box appears and then disappears immediately. my computer tool bar shows no running programs after i hit the start service button. I installed no security software. I have completely removed it all from my computer. i have even tried to shut off windows security and try but this doesn't work either. I do not use windows defender. Thanks

[morny]

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 - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ ) Can't Connect / Failed to Start PostgreSQL
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all) PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe