Thread: Running DBT2 on postgresql

Running DBT2 on postgresql

From
Rohit Goyal
Date:
Hi All,

Please help me in running DBT2 on postgresql. I am doing it for the first time. I am facing error while running dbt2 test.

I installed dbt2 by following "install" file. Below some final lines of terminal.

Install the project...
-- Install configuration: ""
-- Installing: /home/abhi/dbt2_install/bin/dbt2-client
-- Installing: /home/abhi/dbt2_install/bin/dbt2-datagen
-- Installing: /home/abhi/dbt2_install/bin/dbt2-driver
-- Installing: /home/abhi/dbt2_install/bin/dbt2-transaction-test
-- Installing: /home/abhi/dbt2_install/bin/dbt2-generate-report
-- Installing: /home/abhi/dbt2_install/bin/dbt2-get-os-info
-- Installing: /home/abhi/dbt2_install/bin/dbt2-post-process
-- Installing: /home/abhi/dbt2_install/bin/dbt2-run-workload
-- Installing: /home/abhi/dbt2_install/bin/dbt2-sysstats
-- Installing: /home/abhi/dbt2_install/bin/dbt2-plot-transaction-rate
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-build-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-check-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-create-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-create-indexes
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-create-tables
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-db-stat
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-drop-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-drop-tables
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-load-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-load-stored-procs
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-plans
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-start-db
-- Installing: /home/abhi/dbt2_install/bin/dbt2-pgsql-stop-db


After that I am following readme_postgresql file. But, I can't understand

"A really quick howto.

Edit bin/pgsql/pgsql_profile.in and follow the notes for the DBT2PGDATA
and DBDATA directory.  DBT2PGDATA is where the database directory will
be created and DBDATA is where the database table data will be
generated.

Set environment variables, see examples/dbt2_profile.

Please explain me the parameters pls. I have set 

export DBT2INSTALLDIR=/home/abhi/dbt2_install  # change where you want install dbt2
export DBT2PGDATA=/home/abhi/project/pgsql/DemoDir  # your postgres database directory
export DBT2DBNAME=dbt2 # keep as it is

I set above parameter before installation.

Regards,
Rohit Goyal



--
Regards,
Rohit Goyal