Poker Software
Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Dec 2008

    Default Moving PostgreSQL databse to another hard drive


    I have tried to move my PostgreSQL databse using these instructions: Hold'Em Manager 2 FAQs - Poker Software :: Move Database to Another Hard Drive or Partition
    Unfortunately I have PostgreSQL 9.0 and some things are different - I did as was told there but in registry editor I have changed /HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\po stgresql-x64-9.0 Data Directory path to my new folder. Now when I try to run HM2 I'm getting error shmeme index entry size is wrong for data structure "XLOG Ctl" : expected 75096 actual 2108696. When I open pgAdmin III I don't have any database listed.

    Best regards,

    I have restarted comnputer and now I'm unable to connecto to postgresql at all. When I try to start it manually I get message that service started then stopped. Can I maybe just uninstall postgreSQL then install it on my external HDD and copy my data folder there?
    Last edited by Ankhes; 10-16-2015 at 07:53 AM.

  2. #2
    Graphics Guru fozzy71's Avatar
    Join Date
    Sep 1971
    HM Support


    If you are moving from a SSD to an external you could suffer a decrease in performance.

    That being said, here are the instructions:

    1) Uninstall PostgreSQL from the Windows Control Panel.

    2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

    net user postgres /delete

    3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

    4) Reboot your PC

    5) Install the same version of PostgreSQL as your previous database from using these instructions - Hold'Em Manager 2 FAQs - Poker Software :: Reinstall PostgreSQL 8.4 while preserving database

    6) Once installed you should disable the postgresql logging as instructed here - Hold'Em Manager 2 FAQs - Poker Software :: Large Log Files

  3. #3
    Junior Member
    Join Date
    Dec 2008


    Can I install 9.4? I can't find 9.0 installer on postgresql site.

    Nevermind found installer.
    Last edited by Ankhes; 10-16-2015 at 09:28 AM.

  4. #4
    HM2! udbrky's Avatar
    Join Date
    Jul 2008


    You can install either. We do not recommend 9.1
    Regards udbrky (Chris)

Similar Threads

  1. Replies: 3
    Last Post: 10-22-2011, 04:23 PM
  2. Moving HM database to new hard-drive
    By smokedog1878 in forum Manager General
    Replies: 5
    Last Post: 07-09-2011, 02:24 PM
  3. Moving database to hard drive & then to new computer
    By Nebulae in forum Manager General
    Replies: 1
    Last Post: 04-07-2011, 11:23 AM
  4. Moving data base to an external hard drive
    By gring000h in forum Manager General
    Replies: 11
    Last Post: 11-27-2009, 12:32 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