Poker Software
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Mar 2009
    Posts
    32

    Default HM cannot connect to database/postgresql server doesnt start

    Yesterday I imported all hands into my new database and everything worked fine. Today I wanted to play some poker, but HM cannot connect. I changed the passwords(user postgres and database passwords) to my own passwords and now I cannot start the postgresql server due to logon failure. Tried to change the password back but that didnt help... Tried to google a bit, but didnt find it since most hits were Linux related. My guess is that it worked yesterday since the server was already running and now it uses the wrong password from some ini file.

    I am not sure thats the whole problem, since Windows didnt respond last night, so I switched it down with the powerbutton.

    Anyway, I really would like to fix it w/o reinstalling postgre. Anyone an idea?

    PS: postgresql version: 8.4 (autoinstalled w HM install), windows 7 HP x64, UAC disabled etc
    Last edited by Doncock; 02-25-2010 at 09:22 AM.

  2. #2
    Graphics Guru fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    23,792

    Default

    1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
    2. Scroll to the bottom and change all md5 to trust. Save and close the file
    3. Move the file back to the data folder
    4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

    HM will accept any password now.

    FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL))
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, you can do so here: Leave Feedback

  3. #3
    Member
    Join Date
    Mar 2009
    Posts
    32

    Default

    I guess we made a mistake. The default user postgres password is postgres. After changing it back to postgres it worked again. Now just find out in which configfile to change the password, but I am lazy and bored, so I will do that later.

    *edit* I think this will do the trick:

    net user accountname newpassword

    Will try it later.
    Last edited by Doncock; 02-25-2010 at 12:00 PM.

Similar Threads

  1. Cant get hm to worl postgresql database doesnt connect
    By aaron in forum Manager General
    Replies: 1
    Last Post: 12-24-2009, 06:34 PM
  2. Windows won't start PostgreSQL server
    By TravisJ in forum Manager General
    Replies: 0
    Last Post: 10-31-2009, 12:31 AM
  3. canīt connect to postgreSQL database
    By ih8rain in forum Manager General
    Replies: 3
    Last Post: 02-19-2009, 04:04 PM
  4. PostgreSQL Database server 8.2 will not start
    By K0TS in forum Manager General
    Replies: 3
    Last Post: 11-29-2008, 10:24 AM
  5. Can't connect to PostgreSQL thru Database Control Panel
    By Alizona in forum Manager General
    Replies: 31
    Last Post: 08-25-2008, 08:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •