PDA

View Full Version : Can't connect to HEM



blind squirrel
07-15-2010, 04:47 PM
Hi there,

during a recent session my hud stopped updating hands, maybe due to harddrive problems. As it prolly just ran out of space and Stars couldn't save them anymore therefore. Not sure.

Anyway, I deleted some stuff and rebooted and now I can't connect, this comes up after the "Connect to PostgreSQL" screen:

http://i522.photobucket.com/albums/w350/blindsquirrelandnoob/hemerror.jpg?t=1279226417

(sry some German but I hope it's okay for English mods too)

Thanks in advance.

morny
07-15-2010, 08:59 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while its starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it.Do not delete any other files

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


If none of those worked Please reboot and 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

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you wont have access to the hands in the old database but since you cant connect to the database your already in that situation. In the case its not possible to reconnect you can either contact the postgreSQL forums who may be able to help with advanced connection issues or you can reinstall. Ive listed 3 postgreSQL forums below
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
Old Nabble - PostgreSQL forum (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (http://www.dbforums.com/postgresql/)

1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
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) Go to Start > Programs (All Programs) > Accessories > Command Prompt > Right-Click on command prompt and choose Run As Administrator
net user postgres /delete
B) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

if that also fails Please follow step A again and try this version PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

blind squirrel
07-16-2010, 09:04 AM
n/m looks fixed now, ty

JamesAusten
02-10-2011, 09:50 AM
Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while its starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it.Do not delete any other files]

This helped me, thanks.