PDA

View Full Version : DB but not PG on external drive for trial



mfm000
12-10-2008, 03:29 AM
I'd like to have the trial version of HM use a db on an external drive.
(But leave PG on the default drive. cf FAqs 101, 154)

With PGAdmin I thought I'd do something like:

CREATE TABLESPACE HM_external LOCATION 'D:\HM_data';
CREATE DATABASE HoldemMgr_newdb TABLESPACE HM_external;
\connect HoldemMgr_newdb
\cd D:
\i HoldemMgr.schema.postgres.sql
\q

Is a copy of the the HM schema file ("HoldemMgr.schema.postgres.sql") available? Where?
Can the trial version be manipulated to use the newly created db?

Thanks.

Al1
12-10-2008, 06:08 AM
Take a look at this thread and tell me if it's what you search to do: http://208.109.95.123/forum/showthread.php?t=4810 (morny's answere)

mfm000
12-10-2008, 01:39 PM
Not quite. Using -D ... has ALL of the Postgres data files relocated.
Other apps included.

I'm looking to have only the HoldemManager data files to a separate
area. Just need to be able to create a HM compatible db there, hence the need
for the schema file import. PG will take care of the rest.

Al1
12-10-2008, 01:50 PM
Not quite. Using -D ... has ALL of the Postgres data files relocated.
Other apps included.

I'm looking to have only the HoldemManager data files to a separate
area. Just need to be able to create a HM compatible db there, hence the need
for the schema file import. PG will take care of the rest.

I see. It's more likely you will find an answere here, because it's something related to postgreSQL: http://www.postgresqlforums.com/

Nevertheless, I will escalate this thread to morny (Support) to see if he has a solution.

mfm000
12-10-2008, 04:09 PM
The schema file required is for the *Holdem Manager* database.
Only HM can provide it, not an outsider.

Thanks for directing my question to one of your tech people.

Rvg72
12-10-2008, 09:24 PM
Can you create an HM DB on the default location and then grab the schema from that? We run a few different scripts and do a few updates so grabbing the DB schema after all of this should give you what you need

Roy

mfm000
12-11-2008, 07:24 PM
Seems to work so far:

CREATE TABLESPACE x_disk LOCATION 'D:\PokerData';
CREATE DATABASE hm_newdb WITH TEMPLATE HoldemManager TABLESPACE x_disk;

Makes a new empty db in another place by copying the current structure of the db.

Then make hm_newdb the HM default database via the Database Manangement menu option.