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
