Running DBT2 on postgresql

From: Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-students(at)postgresql(dot)org
Subject: Running DBT2 on postgresql
Date: 2014-05-12 17:16:16
Message-ID: CANqGtSuGsHk44X3xkuDhTMW_MOZ1uz-vUz4rnF9o7UGN1neynA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-students

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-05-12 17:16:59 Re: cannot to compile PL/V8 on Fedora 20
Previous Message Ants Aasma 2014-05-12 17:06:39 Re: Proposal for CSN based snapshots

Browse pgsql-students by date

  From Date Subject
Next Message Josh Berkus 2014-05-12 18:50:56 Re: Running DBT2 on postgresql
Previous Message Tom Lane 2014-04-30 21:41:57 Re: GSoC on WAL-logging hash indexes