Postgresql error

[sholomo]

So few days ago I had to reinstall my windows XP because it crashed coz of some reason which I guess is not important at this point. I haven't format disk or reinstall XP but used "repair" so I was able to keep all important files on my PC including HEM database. After I completed XP installation I had to reload all my drivers and install updates for XP from beginning, and there was the first problem with my ethernet driver which acted weird, sometimes it allowed me to connect through internet sometimes it didnt, I have finally installed the final update for it, which made it connecting to internet without much problems, but it still has status: limited or no connectivity eventhough it works fine :confused: . I belive that might be one of the problems connected with me Postgresql error which I get just after I try to start HEM
"The following error occurred when trying to open the database: Failed to establish connection "127.0.0.1"

I have read some of similar problems u discussed on these forums, tried with services.msc, eventviewer, and nothing makes the difference.

Also my ethernet controller is standard motherboard controller as I saw someone already suggested to try this, if u use something else.

Now my first question is if it is possible to get backup for holdem manager database anyhow else than the suggestion on main site? because when i try to open the server it says:
server doesn't listen
could not connect to server: connection refused (0x0000274D/10061) is the server running on host "127.0.0.1" and accepting tcp/ip connections o port 5432 ?
so thats my main concern for now, I can try to reinstall Postgresql but I really would not like to lose my database.

[fozzy71]

The bolded step 2 below is how you reinstall postgresql using your current database. Follow all of the steps and don't hesitate ask if you have any problems or questions.


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

[sholomo]

step 2 worked, thank you :)