Cannot connect to postgreSQL DB

[Koniflush]

Hello

I was late to update my HEM2 version. Today that's impossible to use the software because of an error to connect to database. I've tried to uninstall/install the soft then update it by following indications on that post http://forums.holdemmanager.com/gene...erruption.html

Unfortunatly I'm still unable to use HEM2.






Thanks for help

[fozzy71]

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

This is usually a firewall or windows update issue and the following guide gives a step by step guide:
http://hm2faq.holdemmanager.com/ques...rt+PostgreSQL+


If you continue to have problems, try the following -

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) Please install the latest version: http://www.holdemmanager.com/downloa...ger_2_Beta.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://hm2faq.holdemmanager.com/ques...rewall%29#MSES
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Microsoft Security Essentials - Microsoft Windows



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 (even if you use a different web browser). This is important because it will install critical updates that affect PostgreSQL and maybe related to the issues you are seeing.


Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F


If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.


Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL.


1) Uninstall PostgreSQL from the Windows Control Panel.


2) Delete the \PostgreSQL\8.x\data folder that is left behind.


3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).


4) Restart your PC


5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloa...er_2_Setup.exe


Start HM2 again and create a New Database.