postgres problem

[pednuts68]

hi , was in middle of playing few tables & noticed hm not coming up on few of latest tables to load. tried to turn hm off but couldnt. screen froze so had to turn computer off. now when try turn hm on says cant connect to postgres server. have tried troubleshooting but cant seem to get it back up. any help much appreciated.

[Maso777]

I was playing yesterday and had no problems, today I tried starting HEM1 it is saying:

"An error has occurred when trying to open database: Failed to establish connection to 127.0.0.1".

[DogNamedBluff]

If you have Win7 (or Vista), consider the following:

1) PC name must be in English and "in one word" - requires reboot after changing.

2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
This means: if you have Russian (or French, or else) Windows - your PC name possibly contains "non-english" letters.
Like "Вася-PC" or "Rene-PC"
The same with windows username. Or spaces in the name.
Postgres doesn't like that - and won't run as a result of it.

3) Secondary logon service must be set to "Autostart".
This 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.

4) UAC = OFF ( How to Disable and Turn Off UAC in Windows 7 « My Digital Life )

5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.

6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.

7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from Download PostgreSQL | EnterpriseDB

8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.

9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.

10) If Postgres install fails - after uninstalling don't forget to kill windows user named "postgres":
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 /del
exactly as shown. You should get a confirmation if it was successful.

11) Run all pokerclients "as admin" too.

If you continue to have problems, please reproduce the issue and attach your log.txt file in an email to support with a link to this thread.-

http://hm2faq.holdemmanager.com/ques...ger+Support%3F