PDA

View Full Version : Postegre connection issues



ZJS
06-03-2010, 03:04 PM
After a big update my windows system did I cannot connect to postgre anymore. When I try to start up HEM I get this message: the following error occurred when trying to open the database: Failed to establish a connection to '127.0.0.1'

I've been browsing through some of the forums to get the easy fix stuff done. I've made sure my UAC is off, and I've made sure its not a firewall or windows defender issue (I turned both of them off seperately and it still didnt work). I don't know what else my windows update did that would not allow the postgresql connection.

Please help me!

jeanchris
06-03-2010, 04:49 PM
Same thing happen for me today too.

Yesterday I had some problem with my electricity, so my computer shutdown couple of time. When I reset it this morning I install some update etc and I can't connect to postgres.

I tried everything possible in the FAQ about this, nothing is working.

jeanchris
06-03-2010, 07:16 PM
I tried everything possible in this page :

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+ )

Nothing work so far, i'm trying to get this work for like 2 hour but always got the same error.

My Status for postgreSQL Server is not started (in admin tools>services)
and I can't get it start I get this : error 1069

jeanchris
06-04-2010, 03:00 AM
bump?

ZJS
06-04-2010, 03:54 AM
yea seriously

netsrak
06-04-2010, 07:24 AM
Please reboot your computer 1-2 times.
If it still doesn't work look for the hidden file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.

Please come back if it still doesn't work.

jeanchris
06-04-2010, 01:24 PM
Like I said previously , I did everything in the FAQ file.

I deleted the pid file, I reboot like 25 times trying to do different thing, nothing is working.....

bdon22
06-04-2010, 05:13 PM
I'm also having this exact same issue. HEM was working for me yesterday perfectly fine, and now today I have this cannot connect issue.

Double checked UAC, firewall, hosts, and even re-installed PostgreSQL and HEM. No luck :confused:

sjeanne
06-04-2010, 05:31 PM
I have same problem

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

bdon22
06-04-2010, 10:35 PM
Deleted postmaster.pid and rebooted - works now. Thanks!

scoop05333
06-05-2010, 07:18 AM
i have tried everything and sent an email days ago about a TV session. any help would be appreciated

netsrak
06-05-2010, 07:45 AM
Sorry for the delay, i can see your request in a colleagues thread. I told him to have a look at it immediately.

scoop05333
06-05-2010, 07:47 AM
cheers much appreciated. i am having to use poker tracker and we all know how bad that is :P

netsrak
06-05-2010, 08:07 AM
but if PT is running your postgresql is ok. You just need to configure the exceptions in your firewall:
FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall) (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)