Reconnecting w/ old database on separate drive
Results 1 to 8 of 8
  1. #1
    Junior Member
    Join Date
    Oct 2010
    Posts
    24

    Default Reconnecting w/ old database on separate drive

    I reformatted my C drive and reinstalled HEM there but have PostgreSQL 9.0 database on another drive. How do I reconnect the two to have it function properly. I get the Database control panel whenever I try to open HEM.
    thanks

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

    Default

    Make sure secondary logon is running: The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

    Reinstall SQL 9.0 to the separate drive.
    It is installed using port 5432 (or 5433?).
    Connect to that port in Database Management (dbcontrolpanel)
    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

  3. #3
    Junior Member
    Join Date
    Oct 2010
    Posts
    24

    Default

    Quote Originally Posted by Patvs View Post
    Reinstall SQL 9.0 to the separate drive.
    It is installed using port 5432 (or 5433?).
    Connect to that port in Database Management (dbcontrolpanel)
    I have my previous SQL 9.0 already installed on that drive. Do I need to uninstall that one and download and reinstall a new 9.0 there?

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

    Default

    No just reinstall it, directing it to the same location.

    Which port is it using? SQL 8.4 is completely uninstalled? Or are both using the same port?
    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

  5. #5
    Junior Member
    Join Date
    Oct 2010
    Posts
    24

    Default

    Quote Originally Posted by Patvs View Post
    Which port is it using? SQL 8.4 is completely uninstalled? Or are both using the same port?
    I do not have SQL 8.4 installed. The port that it is using 5432. I try to start up HEM and it still can't locate the database at port 5432.

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

    Default

    But it can connect to port 5432?
    You can't create a new database--> reimport your hands?
    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

  7. #7
    Junior Member
    Join Date
    Oct 2010
    Posts
    24

    Default

    Quote Originally Posted by Patvs View Post
    But it can connect to port 5432?
    You can't create a new database--> reimport your hands?
    HEM can't connect to 5432. Are you suggesting that I format my X:drive database where I have my hands and re-import all my hands?

    Can I remove my database folder? Format the drive and recopy the folder and reinstall SQL 9.0?
    Last edited by ReyzorxXx; 02-27-2011 at 09:50 AM.

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

    Default

    If you can't connect.


    This is usually a firewall or windows update issue.

    First try to reboot.

    If no help, try this:

    Start > Programs > PostgreSQL > 8.x > Stop Service

    Start > Programs > PostgreSQL > 8.x > Start Service

    If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


    If that doesn't help you will have to reinstall PostgreSQL completely



    If that still fails, install a different version of SQL to a different port and connect to that instead.
    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

Similar Threads

  1. Replies: 9
    Last Post: 12-03-2010, 04:43 PM
  2. Copy database to other drive
    By Pilequinha in forum Manager General
    Replies: 3
    Last Post: 09-28-2010, 05:25 AM
  3. Old database on external drive
    By TFZ in forum Manager General
    Replies: 3
    Last Post: 05-20-2010, 05:29 PM
  4. Running HM on separate hard drive
    By etant39 in forum Manager General
    Replies: 3
    Last Post: 10-22-2009, 10:11 PM
  5. Database on a new drive
    By Dzsenaj in forum 3rd Party Programs Compatible With HM2 or HM1
    Replies: 1
    Last Post: 08-28-2009, 09:52 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
  •