Error after moving DB to another partition.
Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Member
    Join Date
    Feb 2010
    Posts
    75

    Default Error after moving DB to another partition.

    Hello.

    I need to move the DB to a new partition in my HD. After following the instructions here:

    FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition

    I restarted my computer and got this error message.



    Need your help please.

  2. #2
    Member
    Join Date
    Feb 2010
    Posts
    75

    Default

    Edited to add this observations:

    1. Maybe the above FAQ needs some changes. For instance, in my Windows register the entry that needs to be modified -In the ImagePath - reads:

    Code:
    C:/Archivos de programa/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "postgresql-8.4" -D "C:/Archivos de Programa/PostgreSQL/8.4/data" -w
    Note the red bolded slashes instead of the dashes that appear in the FAQ.

    Anyway, I tried with the slashes and got the same error message, so for the moment I gave up.

    2. Since the weekend is already here and I didn't want to play without the HM I uninstalled all and made a clean installation, and then I noticed that although I asked Holdem Manager to install in the bigger partition, PostgreSQL installed in the smaller one, the one that contains Windows.

    So, basically the DB move failed and I can´t get Postgres installed in the partition of my choice.

    That is it.

    Help will be most welcome.

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

    Default

    You need to copy and paste the data folder to the drive you want to move it to, the guide just shows how to set it up after you move it to connect sucessfully, ill take a look at that FAQ and get it updated, if your still having issue maybe we can do a teamviewer session to troubleshoot the problem, please email me with a suitable time to do the session and also the timezone your in.

    support@holdemmanager.com
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  4. #4
    Member
    Join Date
    Feb 2010
    Posts
    75

    Default

    Quote Originally Posted by morny View Post
    You need to copy and paste the data folder to the drive you want to move it to, the guide just shows how to set it up after you move it to connect sucessfully, ill take a look at that FAQ and get it updated, if your still having issue maybe we can do a teamviewer session to troubleshoot the problem, please email me with a suitable time to do the session and also the timezone your in.

    support@holdemmanager.com
    Hello Morny.

    I’ve been making some tests to try to understand what’s going on.

    1. The data folder is moved to it’s new location

    2. I stop the Postgres service, which is set as Automatic

    3. Without making any changes in the register I restart the computer, go check the service and it appears as Started

    4. I stop it and then I make the changes in the registry with the new path to the data.

    5. I reset

    6. I check the Postgres status and it shows Starting -notice NOT started-

    7. I change again to the original settings, restart and Postgres has started.

    Kind of weird huh? Changing the path to the data files is messing with Postgres connectivity...

    I don’t see how a remote session will change this, so if you think about my report above and come with an idea that I can test maybe we can both save some time. I very much appreciate your willingness to help me thu.

    Best.

  5. #5
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Seems like moving the data folder is not working for your postgresql installation.

    Create a backup of your database via pgadminIII.
    Uninstall postgresql.
    Reinstall postgresql on the new partition
    Restore the backup

  6. #6
    Member
    Join Date
    Feb 2010
    Posts
    75

    Default

    Quote Originally Posted by netsrak View Post
    Seems like moving the data folder is not working for your postgresql installation.

    Create a backup of your database via pgadminIII.
    Uninstall postgresql.
    Reinstall postgresql on the new partition
    Restore the backup
    The problem is that if I install postgresql using the combo from Holdem Manager, it automatically goes to the old partition, as I already pointed out.

  7. #7
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    You need to download and install a version from PostgreSQL: The world's most advanced open source database

  8. #8
    Member
    Join Date
    Feb 2010
    Posts
    75

    Default

    I can`t find the downloader for PostgreSQL 8.4 for Windows. I´ve looked here without success.

    PostgreSQL: Windows packages

    Can anyone point me in the right direction?

    Thx.

  9. #9

  10. #10
    Junior Member
    Join Date
    Jul 2008
    Posts
    19

    Default

    Note to HEM admins. Though not sure if the following is Gato's problem.

    The FAQ is slightly wrong. If you just copy and paste your data folder in PostgreSQL it WILL NOT copy all the required security settings.

    You can either go to your new Data folder and add security settings (Full Control) for user postgres. (right-click->Properties->Security)
    Or,
    use xcopy to copy the folder like:

    xcopy "C:\Program Files\PostgreSQL\8.3/Data" "I:\Program Files\PostgreSQL\Data" /O /X /E /H /K

    This will retain all the security permissions.

Similar Threads

  1. Installing PostgreSQL on another partition
    By agc1976 in forum Manager General
    Replies: 3
    Last Post: 11-29-2009, 12:22 PM
  2. Postgres on Partition
    By madlion in forum Manager General
    Replies: 1
    Last Post: 04-12-2009, 04:37 PM
  3. Move a db to another partition
    By florinel26 in forum Manager General
    Replies: 1
    Last Post: 12-19-2008, 11:00 AM
  4. database movement to partition?
    By thesantini in forum Manager General
    Replies: 17
    Last Post: 08-26-2008, 12:36 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
  •