PDA

View Full Version : HM Suddenly Stopped Working



Havagohero
02-24-2010, 06:53 PM
Hey,

any help much appreciated with this...

HM stopped working before i installed the new update. i have now done this and it is still not working. when i try to open it, it comes up with the message:
'the following error occurred when trying to open the database: failed to establish a connection to 127.0.0.1.
i then press 'ok'
and it comes up with a database control panel with server name, port name and postgres login and password. i click 'connect' and it reads
'a connection to postgresql could not be made.'

i followed this link which support provided

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+)

i have uninstalled the security software i had (avast) and also turned off my windows defender and firewall. when it came to the exceptions i added the port number and hm to the list, like instructed i could not however see the other 3 options (hud.exe etc) available in the programs to put them on the exceptions list.

i did not recieve any windows updates in the time that hm was working fine and then stopped.

i am unsure about doing the other things that have been listed in that link because i really dont want to lose my database of player stats. i am sure something like this will happen again and i dont want to just keep starting a new database each time.


thank you for your help with this

netsrak
02-25-2010, 10:25 AM
Did you try to restart your computer?

Did you look for the hidden file postmaster.pid in the postgresql data folder, delete it and reboot again?

Havagohero
02-25-2010, 04:08 PM
hey,

yeah i did restart it. no luck.

when i do a search on my computer i come up with postgresql file and it is trying to install postgres again. it then asks for a password. i tried 'postgrespass' but that isnt right. i dont remember ever setting a password or being given one.

?

morny
02-25-2010, 09:26 PM
Heres some things to try, some of them you may have already done so just bypass them, if you have no luck there is uninstall and reinstall instructions at the end

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

wagon30
02-26-2010, 08:11 AM
I am having this same problem. It's happened before to. I know exactly what I did wrong. I started downloading the full version of HEM instead of the update, cause I thought it was the trial for leakbuster. Now I realize that isn't how it works, but it always confuses me.

I think it messes with my port. I think it adds a number or something. Instead of connection to 5432 it changes to 5433. Last time I had to tell my postgres to connect manually somehow, but I can't seem to fix it this time. Can anyone help? Does this sound familiar?

wagon30
02-26-2010, 10:14 AM
Fixed by reinstalling postgres and changing the port.