Folder postgres_wGEO includes create scripts for all necessary schemas
including i2b2 and ETL. It has the same data loaded as the db dump included in
postgres_wGEO_dump folder. 

To create database:
psql -h localhost -U postgres -d transmart -f create-transmart-db.sql

Edit tablespaces.sql (in this case for IC VMs)
sed -i -e "s|__TABLESPACES_DIR__|\/opt\/TM_tablespaces|" tablespaces.sql

To create schemas
psql -h localhost -U postgres -d transmart -f create-main.sql

=============================================================================
In PostgresMigrate Branch:
  the folder postgres contains scripts for building the postgreSQL demo DB
  the file transmart.dmp.tar.gz is the original Oracle-based dump file; used
    to reconstruct the transmart demo database for Oracle.
    
    Create scripts in postgres folder 
==============================================================================

These notes refer to transmart.dmp.tar.gz

Full schema dump of the transmart schema using oracle's expdp data pump utility

This transmart database dump includes 3 GEO studies with clinical data in the dataset explorer
and 7 GEO studies in the search tool.

Note: see branch 'postgresMigrate' for directory (postgres) of scripts and Readme.txt
to build the PostgreSQL database for the PostgreSQL version of transmartApp.

Following schemas are included in the dmp file:
I2B2DEMODATA
I2B2METADATA
I2B2HIVE
I2B2WORKDATA
I2B2SAMPLEDATA
I2B2PM
DEAPP
BIOMART
SEARCHAPP
BIOMART_USER
TM_LZ
TM_WZ
TM_CZ