cant connect after update 1.11.05
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    32

    Unhappy cant connect after update 1.11.05

    hi,

    after update to 1.11.05, i cant connect to postgresql. DBcontrol panel says a connection to postgresql couldnt be made. would you like to HM start the service? I click yes and HM starts the service but when i try again it doesnt work.
    Can you help me please?

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    This is usually a firewall or windows update issue.

    First try to reboot.

    If no help, try this:

    Start > Programs > PostgreSQL > 8.x > Stop Service

    Start > Programs > PostgreSQL > 8.x > Start Service

    If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.



    If that doesn't help you will have to reinstall PostgreSQL completely
    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 this here

  3. #3
    Member
    Join Date
    Dec 2008
    Posts
    32

    Default

    Hi,
    i share my database using an usb key. There is only a postmaster.opts file on it.
    Is it the one i have to delete ?

  4. #4
    Member
    Join Date
    Dec 2008
    Posts
    32

    Default

    i have a new problem trying to uninstall postgresql : "the folder path 'program files' contains an invalid character so uninstall doesnt work
    What can i do to reinstall postgresql but not losing my DB??

  5. #5
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    You don't have to uninstall SQL.
    Just reinstall the 8.4.5 installer from PostgreSQL: The world's most advanced open source database which will update your current installation.

    Don't delete the postmaster.opts file
    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 this here

  6. #6
    Member
    Join Date
    Dec 2008
    Posts
    32

    Default

    my postgresql is 8.3 version. When i installed 1.11.04 i had some problems thats why i keeped 8.3 version...

  7. #7
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Please check the standard things again:

    1. Reboot your computer
    2. If that doesn't help look for the hidden system file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.
    3. Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"
    4. Check our FAQ:
    FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL

    If you need to reinstall postgresql please use 8.3 again and you should be able to connect to your database again: FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database


    I don't like this shared database solutions with an USB stick or external HDD. In my opinion they are very unstable if you don't stop the postgresql service and disconnect the USB stick every time before you change the PC.
    At least you should run a backup of the postgresql database very often.

    But this problem has nothing to do with the HM update you installed. All HM versions use the same database connection.

  8. #8
    Member
    Join Date
    Dec 2008
    Posts
    32

    Default

    ok, it doesnt work so i have to reinstall it... problem is when i try to uninstall postgresql : "the folder path 'program files' contains an invalid character so uninstall doesnt work.
    What can i do to uninstall then reinstall postgresql but not losing my DB??

    PS : i think i'm gonna install it on my local HD and when occasionnaly i'll play on my notebook, i'll import hands. So ?...

  9. #9
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Sounds like something is corrupt with PostgreSQL most likely its looking up a registry key and that registry key has some weird character in it, youd need to check the PostgreSQL forums for a guide to fix something like that as i never seen it before.

    if you cant get access to your database do you have all your hands archived in the C:/HMarchive folder?

    Can you try to restart the service again via Control Panel > Administrative Tools > Services and look for PostgreSQL and click start. It will time out after several minutes and give an error. Then go to the event viewer and under applications in there it should give an error message, can you copy and paste those details here or post a screenshot

    How to open event viewer in Vista or Windows 7
    Event Viewer in Windows 7 | help.artaro.eu
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  10. #10
    Member
    Join Date
    Dec 2008
    Posts
    32

    Default

    hi,

    yes my hands history seems to be safe.
    But i uninstalled postgresql and now i think it would be better to re-install HEM then import hands from my safe archive folder.
    How can i process to do that ? (considering now i just want to use HEM on my desktop computer, saving hands on my hard disk).
    Than you again

Similar Threads

  1. Replies: 1
    Last Post: 05-07-2010, 12:25 PM
  2. HEM can't connect to server to update registration
    By slush420 in forum Manager General
    Replies: 5
    Last Post: 02-21-2010, 10:40 PM
  3. Win7 Update now Cannot Connect
    By gadzooks64 in forum Manager General
    Replies: 8
    Last Post: 01-22-2010, 12:56 PM
  4. Help Please. Cannot connect.
    By uncfelt1147 in forum Manager General
    Replies: 1
    Last Post: 01-19-2010, 11:59 AM
  5. HEM won't connect to SQL
    By tkdkillermiller in forum Manager General
    Replies: 1
    Last Post: 04-18-2009, 12:11 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
  •