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.
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.
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.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.