PDA

View Full Version : Win7 Update Now cant start Postgresql



mrhobbeys
06-09-2010, 12:03 PM
yesterday my Win7 Updated and I did not try to turn on my HEM until today but now I am unable to start the postgreSQL server.

I would set the different parts of postgreSQL to start as admin but I was not sure what parts I should try.

mrhobbeys
06-09-2010, 02:26 PM
Sorry I should have noted the following:

Win 7 64x

HEM 1.11.01b

PostgreSQL 8.4

When trying to open pgAdmin III:

"Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"


When trying Start Server:

"System error 5 has occurred.

Access is denied."

The results are the same when I disable the firewall, and after restarting the computer twice.

mrhobbeys
06-09-2010, 02:41 PM
After editing the hosts file (just restarted and confirmed that the file was edited), still nothing same errors and problems!!

morny
06-09-2010, 11:04 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) - 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

mrhobbeys
06-24-2010, 05:58 PM
Just wanted to give a quick update.

I tried everything on the list right up to the point where I was supposed to install postgresql again instead I just downloaded the full installer from this site and only selected postgres install.

None of the other things worked but that did. Just so you know for future similar problems.