PDA

View Full Version : hm1 postgresql problem



tempo
07-17-2015, 04:21 PM
hi, hm1 roughly worked well until a few months ago. I use the 1.14.02 release. Since I have a problem of connection with postgresql. I tried several solutions read on the forum, but the problem persists. One day the software is operating normally, and some day postgresql refuses to connect. There is apparently nothing changed between days or it works and those where it does not. Would you have a solution? The problem is very annoying. thank you

Patvs
07-17-2015, 08:58 PM
Which Windows version are you using?
What sort of Firewall / Antivirus software?

Did you add postgres.exe, pg_ctl.exe (this file starts the PostgreSQL server), and port 5432 to the exceptions list of Windows Firewall, your firewall, and antivirus software? Read: http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

tempo
07-18-2015, 11:02 AM
i'm using windows 8.1 64b.
windows firewall/Avira

Exceptions list ok
All it's ok but Postgresql cant connect 127.0.0.1
I really don't understand why!

fozzy71
07-18-2015, 11:56 AM
Avira causes major issues. It blocks the database folder, keeping us from writing to it. In some cases, we have seen Avira corrupt Windows to the point the hard drive needs to be reformatted. We do not recommend using it at any time. We recommend Microsoft Security Essentials or Kaspersky for the lowest chance of HM2 conflicts while staying protected against viruses.

Many of those free Norton, Mcaffee, Comodo, Zonealarm, Avira, Avast, AVG, Bitdefender, 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) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - http://hm2faq.holdemmanager.com/questions/1011/Software+Security+Problems+%28Firewall%29#MSES
4) Install Microsoft Security Essentials for antivirus/malware protection and update it - Microsoft Security Essentials - Microsoft Windows (http://www.microsoft.com/security_essentials/)

If you continue to have problems:

This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it’s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

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 - Windows Firewall / Defender Problems

If none of those worked Please reboot and try following these FAQs, step by step:

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

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you won’t have access to the hands in the old database but since you can’t connect to the database your already in that situation. In the case it’s not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. I’ve listed 3 PostgreSQL forums below
PostgreSQL Help (http://forums.devshed.com/postgresql-help-21/)
http://old.nabble.com/PostgreSQL-f759.html
PostgreSQL | dBforums – Everything on Databases, Design, Developers and Administrators (http://www.dbforums.com/postgresql/)

1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
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:

The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. 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.

Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:

net user postgres /delete

Try installing this version of PostgreSQL – http://rvgsoftware.fileburst.com/Postgres_8.3.9-v1.0.7.exe
If that also fails Please follow step A again and try this version
http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip

tempo
07-18-2015, 02:24 PM
omg!
First point: i don't understand this: (sorry im french :( )

Uninstall any 3rd party security software bundles.

Second point: I don't want uninstall avira for microsoft security essentiel. can we do without microsoft security essential?

Thx

fozzy71
07-18-2015, 02:53 PM
You can try the other steps but if avira is causing the problems it will have to be uninstalled or you will have to work with their support to try and fix this issue.