Windows 7 problem Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL

[poker_limit]

Pls help i have try out few solution of the forum but still not solve it

[netsrak]

Please check this:
FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL
FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall)

[poker_limit]

Please check this:
FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL
FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall)

i really dunno how to solve it..... this is the error i get during install

Output folder: C:\PSQLINSTALL
top level install dir -->C:\Program Files (x86)
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
Extract: PsqlTestClient.exe... 100%
Extract: libpq.dll... 100%
Extract: vcredist_x86.exe... 100%
Execute: "C:\PSQLINSTALL\vcredist_x86.exe" /q:a
firewall enabled: 1
firewall port 5432 enabled: 1
port 5432 already enabled
installdir: C:\PSQLINSTALL
try pass: postgres
try pass: postgrespass
Connection to database failed: -->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?
<--error
1
testclient return status: 1
testclient return from file: 1
granting write permission on top level postgres directory
found dir
try rename C:\Program Files (x86)\PostgreSQL\8.4 --> C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-03-Feb-23-16-06
Create folder: C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-03-Feb-23-16-06
Moving files: C:\Program Files (x86)\PostgreSQL\8.4\*.* to C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-03-Feb-23-16-06\
Remove folder: C:\Program Files (x86)\PostgreSQL\8.4\
renamed dir
wrote testfile
Delete file: C:\Program Files (x86)\PostgreSQL\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
installdir: C:\PSQLINSTALL
try pass: postgres
try pass: postgrespass
Connection to database failed: -->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?
<--error
1
testclient return status: 1
testclient return from file: 1

[netsrak]

Please try the basic postgresql installation from ruby on rails postgresql open at postgresq.org

Try 8.4 first, if that doesn't work try 8.3.

Please come back if you need further help.

[poker_limit]

i have try out both of 8.4 and 8.3 but still not work for me.. pls helop
Thanks

[netsrak]

What error messages do you get?

Any 3rd party firewall or anty-spyware, adaware etc. in use?
Which virus scanner?

[poker_limit]

Connection to database failed: -->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?
<--error
1
testclient return status: 1
testclient return from file: 1


McAfree

[morny]

This is usually a firewall or windows update issue. It seems to be a connection issue so ive listed all the connection solutions below, some may not apply and if so just skip to the next one

First try to reboot.

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 - 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 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 PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums

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/downloa...ager_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/downloa...3.9-v1.0.7.exe

[poker_limit]

how to add it at this place? Thanks~

[morny]

Youll need to refer to user manual or contact their support as im not familiar with it but i would say its either inbound rules or outbound rules