How do I move HEM from C drive to external drive?
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jul 2008
    Posts
    84

    Default How do I move HEM from C drive to external drive?

    I have HEM and Post SQl but my C drive is getting full.

    How do I move it all to my external drive? Will it be complicated? Might there be problems doing so?

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

    Default

    It is the postgresql database that takes the bulk of the room. You might be able to save some space initially by turning off logging and deleting the postgresql log files.

    To move your postgresql database use this faq - http://www.holdemmanager.net/faq/?f=101


    To turn off the logging and delete your log files:



    Logging:

    I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips


    To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

    - Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

    - C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

    - Scroll about half way down to ~Lines 245 - 260:

    - The last line of this block of code, for the 'logging_collector', must be changed from On to Off.

    PHP Code:
    ------------------------------------------------------------------------------
    # ERROR REPORTING AND LOGGING
    #------------------------------------------------------------------------------

    # - Where to Log -

    log_destination 'stderr'        # Valid values are combinations of
                        # stderr, csvlog, syslog and eventlog,
                        # depending on platform.  csvlog
                        # requires logging_collector to be on.

    # This is used when logging to stderr:
    logging_collector off        # Enable capturing of stderr and csvlog 
    File > Save; File > Close

    Start > Programs > PostgreSQL 8.3 > Reload Configuration.

    *edit:
    - Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.



    If you want to reinstall your actual holdem manager to the other drive also:


    Before you uninstall HM:

    I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done? - http://www.holdemmanager.net/faq/afm....aspx?faqid=98

    You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. http://www.holdemmanager.net/faq/?f=119. I usually just copy my entire \Holdem Manager directory.

    I would also make sure you manually export the database to hand history text files:

    HM > Options > Database Management > Connect > Export Hands

    How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afm...aspx?faqid=173

    Make sure you copy that folder as well as the other stuff I mentioned.

    This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.


    If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

    Turn off Windows Firewall for installing HM and PostgreSQL. You must also add exceptions to the Windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171

    1) Make a backup of your C:\Program Files\RVG Software\Holdem Manager\Config folder, and any other important files mentioned earlier.
    2) Uninstall HM with www.revouninstaller.com using the Deep setting.
    3) If given the option, on the 2 following screens of Revo, choose the Select All > Delete buttons to remove any registry entries and leftover files.
    4) Reboot your computer
    5) Install the complete setup of HM: http://www.holdemmanager.com/downloa...demmanager.zip
    6) Download the latest patch HM: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe
    7) Test if it for a while and see if it work
    8) Close down Holdem Manager and rename the current, working \config folder to \config_original. Now copy your \config folder from step 1 and paste it to your C:\Program Files\RVG Software\Holdem Manager\ fodler, to replace the one you just renamed.
    9) Test if it works again for a while
    10) If your old config folder causes problems, you can paste the contents of the \config_original folder back in.
    11) Now you can import any notes and hud configs.

  3. #3
    Member
    Join Date
    Jul 2008
    Posts
    84

    Default

    "*edit:
    - Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process."


    Thanks. I had about 3000 files in that log and deleting them alone cleared up 10GBs of memory on my C drive. I went from only 6% free space to 20%. I'll skip the transfer process for now. It seems complicated.

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

    Default

    I admit it is a bit wordy, but it is a relatively straight forward process. If you get to that point again, and need some assistance, feel free to ask for my remote support assistance.

Similar Threads

  1. Replies: 10
    Last Post: 10-07-2009, 03:00 AM
  2. External Hard Drive
    By Bingo_Babe in forum Manager General
    Replies: 1
    Last Post: 03-05-2009, 12:47 AM
  3. migrating my DB to an external drive - some questions
    By daiquiri in forum Manager General
    Replies: 3
    Last Post: 02-03-2009, 09:42 PM
  4. Forcing same drive letter for external HD
    By housenuts in forum Manager General
    Replies: 4
    Last Post: 01-22-2009, 03:57 PM
  5. DB but not PG on external drive for trial
    By mfm000 in forum Manager General
    Replies: 6
    Last Post: 12-11-2008, 07:24 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
  •