Problems with my database.
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Oct 2017
    Posts
    60

    Default Problems with my database.

    Hello HM Support, the last time I tried to open HM2 they couldnt connect to the postgresql, so as adviced reseted the password. The thing is that:
    -All of my data was formated.

    -The HM2 isnt working properly.

    I want to reinstall the postgresql, what do you recommend me to do? uninstall the entire softwere and reinstall it?

    P.s: Do you know where could I find my old database?

    Thank you.

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

    Default

    The old database is most likely unrecovereable.

    Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts and multiple 'check for updates'), including Internet Explorer (even if you use a different web browser).

    Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

    If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

    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).
    - If you can't see it, turn off the windows option that is hiding that directory - http://faq.holdemmanager.com/questio...es+in+Windows+

    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 - http://hm2faq.holdemmanager.com/ques...arge+Log+Files

    If there is still an issue, we need to know the error - it is in the %Temp% folder - bitrockinstaller.txt file. *If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio...es+in+Windows+

Similar Threads

  1. Restoring to new database kills off old database
    By JtX in forum Manager General
    Replies: 12
    Last Post: 10-05-2010, 08:27 PM
  2. Restoring a Database Using backup and restore Made a different database disappear!
    By onlymymissiscallsmedonkey in forum Manager General
    Replies: 3
    Last Post: 07-12-2010, 08:56 PM
  3. Replies: 5
    Last Post: 06-24-2010, 09:36 AM
  4. Replies: 1
    Last Post: 06-16-2009, 01:44 PM
  5. New database - HUD on old database
    By manon in forum Manager General
    Replies: 1
    Last Post: 02-20-2009, 10:04 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
  •