PDA

View Full Version : A connection toPostgreSLQ could not be made



Raekw0n1
08-15-2014, 04:49 PM
Hi i haven't used HEM1 in a year or so and when i try i get the following error message.

A connection to PostgreSLQ could not be made. Would you like to have Holdem manager attempt to start the service?

I cant seem to get it working. I tried restarting my computer. Restarting the server for PostgreSLQ 8.4.

What should I do?

Patvs
08-15-2014, 05:33 PM
Turn on the secondary Logon. 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. Starting it once should insure it works in the future also.

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. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely.
If 8.4 won't run/install, install 8.2 to port 5433: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

Raekw0n1
08-16-2014, 10:50 AM
I have tried all of this and still no luck. The only thing I couldn't find was the \postgresql\8.x\data\postmaster.pid file.
I have eve uninstalled PostgreSLQ but it wont let me re install it.
Is there anything else I can do?

fozzy71
08-16-2014, 05:48 PM
That file is not always there so it is nothing to be concerned with if you do not see it.

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 - Microsoft Security Essentials - Microsoft Windows (http://www.microsoft.com/security_essentials/)


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


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



net user postgres /delete


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