PDA

View Full Version : Data base problems CONSTANT



rover222
02-15-2010, 09:10 AM
Getting very frustrated with the constant SQL problems.

I have done everything they have said in the forums.

remove spyware or antivirus protection no windows defender just do not know what else I can do.

I'm sure you know the message (the following error occurred while trying to open the database unable to read from the transport connection. An established connection was aborted by the software in your host machine


Do the stop service start service thing and somtimes it helps but then i get errors within athe application.

have tried rebootting...... uac is off of course .........using vista

I actually spend more time trying to fix this problem then I do playing poker.

Very very frustrating to say the least.
I simply don't know what to do next, please help me

morny
02-15-2010, 01:41 PM
Hi,

I understand it can be frustrating but in fact these issues are almost always caused by either windows updates or firewall/antivirus etc

I know you mentioned you tried everything but ill attach the full list of things to try because if you have tried everything the only thing left to do is to reinstall PostgreSQL fresh and reimport all your hands so you may want to try any of the steps below you havent already before you resort to that

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