PDA

View Full Version : PostgreSQL problems, cannot connect to database



zed33
02-28-2010, 05:10 PM
I recently did a reinstall and decided to start from scratch with HEM, including a brand new installation of hem and postgres, and a brand new database. I configured it a few days ago and got it working and importing on the sites I wanted.

Today when I started HEM an error came up that it failed to establish a connection to 127.0.0.1. I tried reinstalling postgres but got the same error. It then takes me to the database control panel and it keeps telling me that a connection could not be made and that HEM failed to start the service.

When I log into pgadmin it keeps popping up with a help box about the server not listening.

The only thing that's changed since last running HEM is that a malware checker "repaired" winsock and I lost internet connectivity and had to do a system restore to about 24 hours earlier (which was still after I had been successfully using HEM).

My firewall is turned OFF.

edit: I'm happy wiping it and starting over, as I said, it's a new database anyway. I just really want to get it up and running for tonight's session! Thanks.

zed33
02-28-2010, 06:30 PM
never mind, i uninstalled and reinstalled both HEM and postgreSQL and it seems to have fixed it.

fozzy71
02-28-2010, 08:59 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