PDA

View Full Version : Postgre problem.



eoincarroll16
08-30-2011, 12:33 PM
Hello guys I'v recently switched laptop and am trying to get HM working on it,
I cannot connect to postgre apon start up I'm getting the 'failed to establish connection to '127.0.0.1''

I tired disabling windows firewall and i uninstalled my other programme (AVG),
I restarted postgre too using admin.
'Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service'

My computer skills and very weak I cannot think of anything else, can someone please help me get this started?
I can provide screen shots of some of the error screens I am seeing.

TY in advance for your help

fozzy71
08-30-2011, 02:19 PM
Did postgresql install successfully and work initially? Or did it never install successfully?

If having problems with install:

If your windows user name has any unique 'cyrillic characters' you will need to create a new windows user and install postgresql under that user. Then you can delete the windows user once it is working.

Create a new windows user in the Control Panel > User Accounts. Make sure it is an Administrator account and name it 'temporary'.

Log in to the new 'temporary' windows user account, and install postgresql using our combo installer:

*Please update to the latest version - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe

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

Once PostgreSQL has been installed successfully you can switch back to your normal windows user account and delete the 'temporary' user from the Control Panel > User Accounts.


If the above does not apply to your situation, follow these steps:

This is usually a firewall or windows update issue.

Which Operating System, Firewall, and Anti-Virus are you using?


Many of those free Norton, Mcaffee, Comodo, Zonealarm, etc, 'internet security' bundles will not work well with holdem manager.

Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:

1) Uninstall any 3rd party security software bundles.
2) Reboot your computer
3) Please install the latest version: http://rvgsoftware.fileburst.com/HmBetaUpdate.exe
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Virus, Spyware & Malware Protection | Microsoft Security Essentials (http://www.microsoft.com/security_essentials/)

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts), including Internet Explorer 9 (even if you use a different web browser) and change your Windows Control Panel > Regional Settings Format to English (USA).

The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

*If UAC is enabled you have to Right-Click > Run As Administrator when you Start/Stop the 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 - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems

Please try following these FAQs, step by step:

1) 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 - http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database
3) 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:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator


net user postgres /delete

4) reboot.
5) Install PostgreSQL 8.3.9 from this link - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

Install it to a new path such as C:\PostgreSQL\8.3 instead of the default installation path.