database movement to partition?
Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1
    Member
    Join Date
    Jul 2008
    Posts
    31

    Default database movement to partition?

    My HEM databases are running large for my partition size. What's the simplest way to either move the database to my other partition or resize the partition? Ideally, I can use a freeware program like Ranish that is executable in Windows. I beleive Ranish is boot only and I'd like to avoid something like that.

    Alternatively, could I install HEM on the other HDD and would I need another code in doing so? This would allow me to export my database and then import it.

    Thanks.

  2. #2
    [Former] HM Support fabio's Avatar
    Join Date
    Jul 2008
    Posts
    2,067

    Default

    You need to install PostgreSQL in your bigger partition.

    You can either export all your handhistories in the database control panel or make a backup from your existing database. I suggest exporting your hands and re-import them later.

  3. #3
    Member
    Join Date
    Jul 2008
    Posts
    31

    Default

    PostGRE is not smart. I've downloaded the install files to install on the partition with space and am trying to install said files however windows is telling me there's not enough space on the primary partition. How do I tell postgresql that I'm trying to install on the other partition?

    Do you know of any freeware partition managers?

  4. #4
    Member
    Join Date
    Jul 2008
    Posts
    31

    Default

    I tried to install postgres on my partition.

    "the port number you entered is already in use. Please specify a different port."
    What port should I use?

    Thanks.

  5. #5
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Is it letting you get to the part where you choose where to install the files and data folder?

    Ive not heard of this problem before, try 5433
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  6. #6
    Member
    Join Date
    Aug 2008
    Posts
    68

    Default

    It's really easy to move a PostgreSQL database to another drive/partition.

    - stop the PostgreSQL service
    - copy/move you 'data' directory to the desired location
    - change the path to the data in the registry :
    the key is HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\pgsql-8.2\ImagePath
    by default it is :
    "C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" runservice -w -N "pgsql-8.2" -D "C:\Program Files\PostgreSQL\8.2\data\"

    You need to change the -D part.

    - exit the services window (where you have killed the service) or reboot
    - relaunch the postgresql service

    Done.

    I did it yesterday, it takes 2 minutes and it works perfectly.
    With this method, you can also put the data directory on an external drive, and as long as you mount it with the same keyletter, it will allow you to share your hands between 2 computers.

  7. #7
    Member
    Join Date
    Jul 2008
    Posts
    31

    Default

    ming,

    I just need to change the "-d" to the drive of my partition?

  8. #8
    Member
    Join Date
    Aug 2008
    Posts
    68

    Default

    Quote Originally Posted by thesantini View Post
    ming,

    I just need to change the "-d" to the drive of my partition?
    yes, with the exact path of your newly copied 'data' directory

  9. #9

  10. #10
    Member
    Join Date
    Jul 2008
    Posts
    31

    Default

    Thanks for the help. I think this should be in the help files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •