Getting postgresql error when starting HEM2
Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    Jan 2011
    Posts
    105

    Default Getting postgresql error when starting HEM2

    Okay until last week my HEM2 was working fine.. now suddenly, I've started getting an error when I start it that says...

    Untitled.jpg

    Uninstalled the postgresql (8.4) that came with the HEM2 download, and went on google to download postgresql.. latest version 11.. and now that installation gives me an error "failed to load SQL modules into the database cluster"

    What do I do?
    Last edited by fizzypants; 05-09-2019 at 08:00 PM.

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

    Default

    The database is corrupted.

    i) Please try to vacuum/analyze and reindex your database - http://hm2faq.holdemmanager.com/ques...29#maintenance

    ii) If you continue to have problems, try the following:

    Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - http://hm2faq.holdemmanager.com/ques...y+played+hands

    If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

    Here is a FAQ explaining how to backup your database and all settings in one easy step - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F


    If you continue to have problems, please duplicate the issue and send us log files with a detailed description of what you were doing and what problems you were experiencing:
    - Open Windows Event Viewer's (Control Panel - System & Security - Administrative Tools or Start - Search - 'Event Viewer') - Windows Logs - Applications.
    - Check for any errors and send the information (Save All Events As...).
    - Please send your \HM2Logs folder files as well - http://hm2faq.holdemmanager.com/ques...ger+Support%3F

    When sending any files please zip them (right-click - send to - compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then right-click - 'copy dropbox link' and paste the download link directly into the support ticket email. If you have any problems with dropbox try using filedropper.com
    Regards udbrky (Chris)

  3. #3
    Senior Member
    Join Date
    Jan 2011
    Posts
    105

    Default

    Hey chris.. thanks much.. actually re-downloading postgres fixed the issue..

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

    Default

    You are very welcome. Thank you for letting us know it solved your problems. It helps us when crafting future replies to other customers with similar problems.

    Good luck at the tables. If you have any further questions or problems do not hesitate to ask us.
    Regards udbrky (Chris)

Similar Threads

  1. PostgreSQL starting error
    By lolzoroflmao in forum General Support
    Replies: 1
    Last Post: 11-25-2011, 04:44 AM
  2. error starting the service: pgsql-8.3. with HEM2
    By Kwet80 in forum Manager General
    Replies: 12
    Last Post: 09-11-2011, 11:12 PM
  3. Getting Error message when starting SitNGo
    By schrambow in forum SitNGo Wizard
    Replies: 2
    Last Post: 11-01-2010, 01:01 AM

Posting Permissions

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