How to configure postgresql on Ubuntu?
Results 1 to 7 of 7
  1. #1
    Senior Member
    Join Date
    Mar 2009
    Posts
    104

    Default How to configure postgresql on Ubuntu?

    I want to run HEM and my poker clients under XP running in Virtual Box under Ubuntu. I thought it would be more efficient to have the db running under native Ubuntu. I remember Netsrak and 'The Minder' writing that they had this configuration. How do I configure postgresql for this?

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523
    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
    Senior Member
    Join Date
    Mar 2009
    Posts
    104

    Default

    Thanks, but that doesn't really help with the configuration. The problem is that the postgre configuration is automated now, which is great for the standard installation but not good if we need something different. Are there any manual postgre installation instructions still about? Even if it's for windows I can probably work it out for Ubuntu.

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

    Default

    Try an older installer from PostgreSQL: The world's most advanced open source database
    8.2/8.3 installers should still give you the options to setup everything manually.
    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
    Senior Member
    Join Date
    Mar 2009
    Posts
    104

    Default

    Problem resolved.
    I set postgresql up manually on Ubuntu, downloaded the latest ODBC drivers on XP. Set up an ODBC connection and it's working fine.

  6. #6
    Junior Member
    Join Date
    Aug 2011
    Posts
    1

    Default

    hi
    Is that configuration more efficient?

    Can you explain more specificly how did you configured it? the postgresql server and the link (?) between postgresql and ODBC.

  7. #7
    Senior Member
    Join Date
    Mar 2009
    Posts
    104

    Default

    I think it's more efficient because you have to allocate processors and memory to the Windows VM, but you still need to hold back most of your processing power and memory to run UNIX. If you run everything under Windows, your UNIX allocated resources are not used and your Windows allocated resources are over-used. Also, having the db and HH files at the top level OS makes sharing across computers simpler (I just use Ubuntu One to synch all my HH files and do a manual import from HMArchive every time I switch machines. I know there is the HM cloud now too but I don't want to use that, at least until it's proven.)

    Anyway, the config above works seamlessly. The connection between UNIX and Windows is a virtual one, so it seems to be just as fast transfer-wise as a connection on one OS.

    I can't remember everything I did, so can't give you a step-by-step guide but here's a few guidelines of what I remember doing. I resolved most problems by googling and managed to hack it all together. Try it yourself and if you get stuck I'll try to help.

    Install VirtualBox on Ubuntu.
    Install PostgreSQL on Ubuntu.
    Set up the HM default user and password for Postgresql - the ones described in the HM doucumentation (postgres and postgrespass?)
    Install Windows on VirtualBox. (Allocate a very large virtual disk as it won't actually be allocated until needed and it's hard to increase the size later. Other settings like memory and processors are easy to reconfigure later.)
    Install VBox extensions on Windows (for seamless mouse usage etc.)
    Install PostgreSQL ODBC driver on Windows and configure connection to postgreSQL running on UNIX
    Install HM on Windows, UNchecking the setting to install PostgreSQL.
    When HM starts and the default local db connection fails, configure a connection to the IP for the postgreSQL server.
    Share folder(s) on your UNIX machine for use by Windows. I created a shared 'HH' (hand history) folder under 'Public'.
    In Windows allocate a virtual drive 'H:' pointed at the 'HH' folder.
    Configure your poker clients and HM to use hand history folders in H: and archive to a H:/HMArchive folder.

    Well that's a start. I'm sure I've forgotten lots. Let me know when you get stuck.
    Last edited by SteveCut; 08-28-2011 at 12:55 PM.

Similar Threads

  1. run hm in ubuntu 10.04??
    By willyskiper in forum Manager General
    Replies: 2
    Last Post: 08-12-2010, 02:09 AM
  2. Holdemmanager with Ubuntu?
    By Silentnoise in forum Manager General
    Replies: 3
    Last Post: 10-22-2009, 09:59 AM
  3. Ubuntu and HEM
    By Dorado29 in forum Manager General
    Replies: 2
    Last Post: 02-20-2009, 10:32 AM
  4. slow import, virtualbox on ubuntu
    By freanki in forum Manager General
    Replies: 12
    Last Post: 10-04-2008, 09:11 AM

Tags for this Thread

Posting Permissions

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