Postgres 9.2
Results 1 to 4 of 4

Thread: Postgres 9.2

  1. #1
    Member
    Join Date
    Jun 2010
    Posts
    83

    Default Postgres 9.2

    Hello,

    I recently started up HEM2 after some inactive time but could not connect to Postgres. I tried reinstalling Postgres( I used 16 for it) but it is still connecting. I think I need version 9.2 but cannot find it anywhere anymore. Any help?

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,775

    Default

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Delete the \PostgreSQL\X.x\data folder that is left behind.

    3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

    4) run the command - start > programs > accessories > command prompt > right-click > run as administrator

    net user postgres /delete
    After you click 'Enter' for the code above also do that same for this code:

    sc delete postgresql-8.4
    and click 'Enter' again.

    5) Restart your PC

    6) Install PostgreSQL 9.3.25 from the link below:
    - https://www.enterprisedb.com/downloa...esql-downloads
    - Skip the 'Stack Builder' option at the end of the installation if prompted.

    7) Once installed you should disable the postgresql logging as instructed here.

  3. #3
    Member
    Join Date
    Jun 2010
    Posts
    83

    Default

    During installation i get the error "Failed to load SQL modules into the database cluster"
    I tried running as admin, did not work. It compelted installation but still same problem with HEM2.
    Last edited by sjokkomoes; 09-19-2023 at 05:07 PM.

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,775

    Default

    Quote Originally Posted by sjokkomoes View Post
    During installation i get the error "Failed to load SQL modules into the database cluster"
    I tried running as admin, did not work. It compelted installation but still same problem with HEM2.
    I am not sure what else to suggest as we don't support HM2 any longer and I personally haven't used HM2 or PSQL since around 2016 when we first started testing HM3 internally.

    I do have one other older 'canned reply' with some slightly different steps for reinstalling PSQL for HM2 that you can try below.

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Delete the \PostgreSQL\8.x\data folder that is left behind.

    3) Delete the sub-folder(s) in c:\users\username\appdata\roaming\HoldemManager\Da tabase (XP - c:\documents and settings\username\application data\HoldemManager\Database).

    4) Restart your PC

    5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloa...er_2_Setup.exe

    Start HM2 again and create a New Database, and make sure to name it differently than the default name.

    *Please update to the latest version - HM2 > settings > check for updates

Similar Threads

  1. Replies: 3
    Last Post: 11-27-2016, 11:33 AM
  2. Replies: 11
    Last Post: 11-23-2011, 10:21 PM
  3. Replies: 1
    Last Post: 08-11-2011, 08:57 PM
  4. Importing Postgres 8.2 Data into Postgres 8.4
    By jskills in forum Manager General
    Replies: 2
    Last Post: 08-15-2010, 08:23 PM
  5. user postgres could not be created . acces denied
    By denkluis in forum Manager General
    Replies: 1
    Last Post: 07-14-2008, 04:06 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
  •