Обсуждение: Running DBT2 on postgresql

Поиск
Список
Период
Сортировка

Running DBT2 on postgresql

От
Rohit Goyal
Дата:
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

Re: Running DBT2 on postgresql

От
Josh Berkus
Дата:
On 05/12/2014 10:16 AM, Rohit Goyal wrote:
> 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.

You'll get more help on the DBT mailing list, which I see you've already
found.

Are you doing this for a GSOC project?  If so, what problem are you
trying to solve with it?

BTW, it's not very friendly to cross-post to 3 mailing lists at the same
time.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com