Moving database to an SSD
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Jul 2008
    Posts
    35

    Default Moving database to an SSD

    Hi,
    so i moved the folders to an SSD drive as this tutorial shows https://hm2faq.holdemmanager.com/que...e+or+Partition

    Is this a correct way to show an image path in registry, because example has a bit different stuff in there?

    D:\postgreSQL\pg10\pgservice.exe "//RS//PostgreSQL 10.5-1 Server" -D "F:\postgreSQL\data"

    F drive is the drive i moved the folders to (SSD).

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

    Default

    What was the exact path of the original?
    Regards udbrky (Chris)

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

    Default

    HM2 and PT4 do not support anything above 9.3 for postgresql so we probably can't help with this. I had 10.5 installed recently testing some things but had to revert back to 9.3. If you can't sort this out on your own it may be easiest to just reinstall psql 9.3 manually to that drive and choose the new parent folder path when creating your HM2 databases in the Database Manager. I will post the reinstall steps below in case you need them:

    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.


    If you cannot access the database in HM2 then you can backup your database using this method 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).


    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 from here.


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


    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+

  4. #4
    Member
    Join Date
    Jul 2008
    Posts
    35

    Default

    Exact path of the original in registry was D:\postgreSQL\pg10\pgservice.exe "//RS//PostgreSQL 10.5-1 Server"
    I managed to get it working somehow, don't want to deal with the reinstall of psql right now.
    Thanks for the reply.

  5. #5
    PostgreSQL Whisperer
    Join Date
    May 2011
    Posts
    890

    Default

    Quote Originally Posted by Vandalar View Post
    Exact path of the original in registry was D:\postgreSQL\pg10\pgservice.exe "//RS//PostgreSQL 10.5-1 Server"
    I managed to get it working somehow, don't want to deal with the reinstall of psql right now.
    Thanks for the reply.
    In this case you can`t move database on another drive or partition because seems like this SQL version doesn`t support it.

Similar Threads

  1. Moving HM2Archive off my SSD
    By aenetomic in forum General Support
    Replies: 3
    Last Post: 07-01-2015, 04:50 PM
  2. Moving HEM/postgres/stars to SSD
    By moexx161 in forum Manager General
    Replies: 1
    Last Post: 02-25-2014, 12:05 AM
  3. Moving HEM 2 to SSD
    By c4nn0n84 in forum General Support
    Replies: 1
    Last Post: 01-13-2014, 11:31 AM
  4. Moving to Win8 and SSD
    By dwallen in forum General Support
    Replies: 1
    Last Post: 05-16-2013, 08:51 PM
  5. Moving to a new PC, tips on licensing & moving DB
    By GrumpyDadPoker in forum Manager General
    Replies: 11
    Last Post: 06-04-2009, 03:42 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
  •