PDA

View Full Version : postgresql database probs



DePosse
02-19-2010, 04:12 PM
Hi, my HEM is working properly at my dorm room comp but at home I cant get it to work. The problem is postgresql. I have tried the default passwords such as dbpass and postgresqlpass but I always get the same warming "cant read data from the transportconnection. The external host has broken a connection".

I have tried putting my firewall off, but that doesn't help at all. I have the latest version 8.4 of Postgre.

Any ideas how I fix this ??

Kind Regards

fozzy71
02-19-2010, 05:50 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.

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)

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

FutureInsights
02-19-2010, 06:10 PM
The problem is the Postgres SQL server.

Please follow instructions at this link:

Pro Poker Plays - Making $5 into $10k Challenge: Holdem Manager Again- Destruction, Tweaks, and Improved Performance (http://propokerplayschallenge.blogspot.com/2010/02/holdem-manager-again-destruction-tweaks.html)