LotteryGuy
08-10-2011, 12:37 PM
Hello,
I am trying to set up similar database setup as I use with the original HEM:
- PostgreSQL server is running on my OpenSolaris server box
- Holdem Manager is running on both my laptop and desktop computers
Now, I first installed HEM2 on my desktop with the default settings, that is, file-based database directory is at:
C:\Users\User\AppData\Roaming\HoldemManager\Databa se
And the PostgreSQL is configured to be on my server box (192.168.10.10).
Now, after finding out there is a file-backed database also (terrible idea btw.), I want to change the location of that to my network share on the OpenSolaris box, so I can use the same database on both my laptop and desktop.
The question is, where can this location be changed?
The second issue came up, when I tried to install HEM2 to my laptop. There is no option to use an existing PostgreSQL database during install, it always insists on creating a new database. I also can't find out, how to change the database after it has created the empty & useless database. So, where is the option?
Then some general comments about the database setup.. I don't understand, why this file-backed database was even created? In general it is a very bad idea to separate data storage into multiple different engines, unless the benefits are good enough. I don't see any benefit in storing data in CSV format in plain text files without any indexing etc.
I am trying to set up similar database setup as I use with the original HEM:
- PostgreSQL server is running on my OpenSolaris server box
- Holdem Manager is running on both my laptop and desktop computers
Now, I first installed HEM2 on my desktop with the default settings, that is, file-based database directory is at:
C:\Users\User\AppData\Roaming\HoldemManager\Databa se
And the PostgreSQL is configured to be on my server box (192.168.10.10).
Now, after finding out there is a file-backed database also (terrible idea btw.), I want to change the location of that to my network share on the OpenSolaris box, so I can use the same database on both my laptop and desktop.
The question is, where can this location be changed?
The second issue came up, when I tried to install HEM2 to my laptop. There is no option to use an existing PostgreSQL database during install, it always insists on creating a new database. I also can't find out, how to change the database after it has created the empty & useless database. So, where is the option?
Then some general comments about the database setup.. I don't understand, why this file-backed database was even created? In general it is a very bad idea to separate data storage into multiple different engines, unless the benefits are good enough. I don't see any benefit in storing data in CSV format in plain text files without any indexing etc.