Postgresql not starting- all instructions followed

[Khiiniau]

I'm totally confused. Yesterday morning I played and used HEM and turned PC of before lunch. In the evening I switched my PC on and tried to start HEM and got that well known "can not connect Postgresql- error". That was confusing because I have given to Windows Firewall and Defender all requested exceptions and in the morning everything worked well and no updates were made during day. Postgressgl just don't start with HEM or manually, it just hangs long time in "Starting" state and finally gives message "Service could not started, servce did not give any error message"

Tried to solve situation but swithing Windows Firewall and Defender of and removed Avira Antivir from my PC, but no succes, Postgresql still not starting. Updated Postgresql and repeated 1.10.02 update for HEM, still same. Uninstalled Posgresql and made new installation, still can not start it.

My OS is Windows Vista Home Premium, all updates made up to 12.2.2010

I'm quite familiar with these Posgresql problems, solved many when used another tracked before HEM and I have helped my friends to solve Postgresql problems in their PCs. But now I'm really surrended because nothing from known solutions helped. Other programs work OK in my PC.

Any ideas how to continue ?

[netsrak]

Which Postgresql versions did you try.

Please download from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
On some computers 8.4 works, on others only 8.3.

[Khiiniau]

I dowlowded Posgres from that site already when I first uninstalled it. I use 8.3 because 8.4 did not work in this PC when I bought it about 8 months ago. 8.3.9 is current updated version.

[morny]

As you mentioned your familiar with what to troubleshoot you may have already tried some of these so just try the ones applicable to you.


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

[Khiiniau]

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

I made already everything else what use proposed, mut did not find before that file. Now I found it, deleted it and HEM works again. Case closed, thank you.