can't get old DB to open on new PC
Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  1. #1
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default can't get old DB to open on new PC

    So I have hard drive with a /postgres/data/ folder that stores my db and that I used on my old windows.

    On the new PC I didn't do a good job installing HM/postgres (why is the combo installer not letting me configure anything for postgres, it just installs it on C where no one wants it)

    I did this http://faq.holdemmanager.com/questio...e+or+Partition
    (have previously done this successfully on the old PC so I don't think I made a mistake there, also tried various times) to link postgres to the right folder. But I cant start the service after setting the new /data/ directory. It times out.

    The old database ran under 8.3, now I got 8.4, is that a problem? How do I get access to the my database?

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

    Default

    Quote Originally Posted by BubbleBoy View Post
    So I have hard drive with a /postgres/data/ folder that stores my db and that I used on my old windows.

    On the new PC I didn't do a good job installing HM/postgres (why is the combo installer not letting me configure anything for postgres, it just installs it on C where no one wants it)
    95+% of our customers install the database to the C:\ drive (their only drive) so we simplified the installer for the majority of our customer base. If you need to install to a different partition/drive, you will need to download a standalone postgresql installer.

    I did this http://faq.holdemmanager.com/questio...e+or+Partition
    (have previously done this successfully on the old PC so I don't think I made a mistake there, also tried various times) to link postgres to the right folder. But I cant start the service after setting the new /data/ directory. It times out.
    This is for moving a database, that is already installed and working, to a new directory. To install an old \data folder to a new machine you need to use the same installer/version that was used to create the database and follow the steps in a different FAQ.

    Please update to the latest beta - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe

    For reinstalling SQL to the same DB, follow these steps:

    1) Uninstall PostgreSQL from the Windows Control Panel.
    2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
    3) run the command - start > programs > accessories > command prompt > right-click > run as administrator
    PHP Code:
    net user postgres /delete 
    4) reboot.
    5) Install the same version of PostgreSQL as your current DB using these instructions - http://faq.holdemmanager.com/questio...g+Old+Database
    6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.

    If your old database is 8.3, and was created with our old/original postgresql.zip you will want to use this installer (8.3.7, I think) - http://www.holdemmanager.com/downloads/postgresql.zip

    If your database was created with the 8.3.9 one-click installer we sometimes link to customers, you will want to use this installer - http://www.holdemmanager.com/downloa...3.9-v1.0.7.exe


    The old database ran under 8.3, now I got 8.4, is that a problem? How do I get access to the my database?
    It is best to use the exact same installer you used originally. If you dont have the same installer you definitely want to have the same major version number, or a slightly higher revision number. If your database was created with 8.3.9 you should definitely not use 8.2, or 8.4, and I would suggest you do not use 8.3.7 or 8.3.8 either.

  3. #3
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    ugh ok

    thanks for the detailed steps

    Can I have 2 postgres versions / postgres users at the same time? Cause I got one old alltime database and now a fresh one just from this PC onward. (If not possible I guess I could just install a second windows on some spare space and put the configure that with the old stuff cause I wont need both at the time..)

  4. #4
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    oh yeah that worked, now Im happy

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

    Default

    Quote Originally Posted by BubbleBoy View Post
    ugh ok

    thanks for the detailed steps

    Can I have 2 postgres versions / postgres users at the same time?.....
    If you need/want 2 different versions, yes you can as long as you install one version to Port 5433 instead of the default Port: 5432.

    Quote Originally Posted by BubbleBoy View Post
    oh yeah that worked, now Im happy
    great

  6. #6
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    Ok I got an old (8.3) database and a new (8.4) database. The new 8.4 was installed first and worked on port 5432. Secondly I installed 8.3 on 5433. Now I could connect to the old db again.

    However now I can't change back to the new db. Both services are running at the same time, the image paths are set correctly. Can't get back to the old db though.

    Now it's kinda strange. pdAdmin, only connects to 8.4 on 5432, but cant connect to 8.3 on 5433. HM can only connect on port 5432 as well, but then finds the old 8.3 database...

    how do I get the old db back?

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Check the registry (with regedit) which port is assigned to PostgreSQL 8.3.
    And manually change it in the registry to 5433.

    (can be a difficult talk to edit the registry)
    Alternatively uninstall PostgreSQL with Revo FREE Uninstaller, then reinstall it.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  8. #8
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    in hkey_local_machine/system/currecntcontrolset/services/pgsql-8.3 or /postgresql-8.4 I don't have anything that looks like a port. where should it be?

  9. #9
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Computer/HKEY_Current_user/software/pgadminIII/server/
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  10. #10
    Senior Member BubbleBoy's Avatar
    Join Date
    Oct 2008
    Posts
    260

    Default

    its set the way it should be, 8.3 on 5433 and 8.4 on 5432

Similar Threads

  1. cannot open hem
    By SnackCheck1 in forum Manager General
    Replies: 1
    Last Post: 09-04-2010, 09:59 AM
  2. 3 bet vs Open from
    By Blade76 in forum German Forum
    Replies: 2
    Last Post: 07-25-2010, 04:45 PM
  3. hm does not open
    By atila in forum Manager General
    Replies: 1
    Last Post: 10-30-2009, 11:16 AM
  4. cant open hem
    By ferrisbueller in forum Manager General
    Replies: 2
    Last Post: 09-04-2009, 10:34 AM
  5. HM does not open
    By deluxesamy in forum Manager General
    Replies: 11
    Last Post: 05-02-2009, 08:29 AM

Posting Permissions

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