PDA

View Full Version : Prostgre help needed ASAP



kylehp33
03-03-2010, 06:44 PM
I installed Prostrage fine
and Holdem Manager

Now when i click the application on my desktop
it open HEM and the first pop up appears
" the following error occured when trying to open database: failed to establish connection to '127.0.0.1"

I click Ok on this

then it comes up with a database control panel
"holdem manager needs to know where to find the database. Please enter the details below and click Connect"

It has stuff entered in all feilds all ready

Server Name - 127.0.0.1
Port number - 5432
log in name - postgres
password - postgrespass

So i click connect
then it says a connection could not be made. would you like to have holdem manager attempt to start a service

so i click yes
"sorry holdem manager was unable to start the service

i click ok
"holdem manager has started the service please try again

I click ok back to origional screen

then it comes up with a database control panel
"holdem manager needs to know where to find the database. Please enter the details below and click Connect"

It has stuff entered in all feilds all ready

Server Name - 127.0.0.1
Port number - 5432
log in name - postgres
password - postgrespass

kylehp33
03-03-2010, 06:45 PM
I dont have any anti virus stuff on i took the kaspersky one of

morny
03-04-2010, 09:49 AM
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


Thanks
Morny
Holdem Manager Support