cannot connect to PostgreSQL, but only after restart
Results 1 to 4 of 4
  1. #1
    Senior Member rowhousepd's Avatar
    Join Date
    Feb 2010
    Location
    Philadelphia, PA
    Posts
    622

    Default cannot connect to PostgreSQL, but only after restart

    I keep getting the "HM2 cannot connect to the PostgreSQL database server" window popup whenever I restart my computer.

    holdem_manager_postgre_connection_problem_with_avast.jpg

    BUT it only happens after restarting the machine ... AND it connects perfectly fine once I go through the steps via the wizard. It just like it keeps forgetting how to connect, but happily everything works out fine. It's a pain to keep having to do, but it's not catastrophic. Any ideas?

    Running Windows 8. Looked this faq, but since I'm able to connect I don't think it pertains to me. Thanks.

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Check on the secondary logon settings in services.

    What ar your antivirus and firewall?
    Regards udbrky (Chris)

  3. #3
    Senior Member rowhousepd's Avatar
    Join Date
    Feb 2010
    Location
    Philadelphia, PA
    Posts
    622

    Default

    Quote Originally Posted by udbrky View Post
    Check on the secondary logon settings in services.
    Not sure what that means exactly. What's a secondary login setting? Basically these are the screens I see when I open HM2 after a system restart:

    1)
    connect.png

    ... followed by 2)
    connect successful.png

    Like I said, this isn't catastrophic because I am actually able to get into my database once I go through the steps in the wizard, but it's weird/annoying nonetheless.

    I use Norton Internet Security and I have pretty much every HM2, postgres, and poker site-related program in the exceptions list, and until recently, I've never had this particular problem with the exact same set up. Fyi, here's part of the exceptions list in Norton. (There are more though):
    norton exclusions.png

    Any thoughts?

  4. #4
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Secondary Logon is a Windows service and it needs to be set to automatic.

    Please see this FAQ to alleviate any security bottlenecks - Hold'Em Manager 2 FAQs - Poker Software :: Set Correct Permissions on files and folders HM2 use
    Regards udbrky (Chris)

Similar Threads

  1. Can't connect to server after PPC restart
    By uselis in forum General Support
    Replies: 9
    Last Post: 02-27-2015, 01:00 PM
  2. Replies: 8
    Last Post: 12-18-2012, 01:46 AM
  3. how to restart postgresql
    By justdoit in forum Manager General
    Replies: 1
    Last Post: 07-10-2011, 10:38 PM
  4. PostgreSQL Restart Problem
    By berikoni in forum Manager General
    Replies: 1
    Last Post: 07-28-2009, 02:20 PM
  5. I have to restart postgresql after reboot
    By RandomRange in forum Manager General
    Replies: 3
    Last Post: 11-24-2008, 12:29 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
  •