Re: Runing DBT2 on Postgresql

On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:

> On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com> wrote:
> > I am trying to install dbt2 on postgresql database.
> >
> > cmake(configure) command work fine and but make command(build) give an
> error
> > given below. I have no idea about how to solve it
>
> ld has become less tolerant of certain flag orderings over time in
> certain distros. The following tweak may be used as a quick-and-dirty
> work around:
>
> diff --git a/CMakeLists.txt b/CMakeLists.txt
> index 6a128e3..f6a796b 100644
> --- a/CMakeLists.txt
> +++ b/CMakeLists.txt
> @@ -11,6 +11,7 @@ SET(DBT2_CLIENT bin/dbt2-client)
> SET(DBT2_DATAGEN bin/dbt2-datagen)
> SET(DBT2_DRIVER bin/dbt2-driver)
> SET(DBT2_TXN_TEST bin/dbt2-transaction-test)
> +set(CMAKE_EXE_LINKER_FLAGS "-Wl,--no-as-needed")
>
> #
> # Check for large file support by using 'getconf'.
>
>
> --
> Peter Geoghegan
>

Hi Peter/All,

I installed the dbt-2 benchmark by implementing the change you mentioned.
Now, I am trying to follow the readme_postgresql for running test on
postgresql, but facing an error in understanding changes in dbt2_profile.
Can you explain my next step:

Could you tel me what to write in how to
set environment variables, see examples/dbt2_profile and proceed further.
Please help me and give me some link to run the test.

I cant find bin/pgsql/pgsql_profile.in file also and when i tried to "Create
a 1 warehouse database by running bin/pgsql/dbt2-pgsql-build-db

and put the data files in '/tmp/data':
dbt2-pgsql-build-db -w 1"

I got the error that dbt2-pgsql-build-db not found.

Please guide!!
--

Regards,
Rohit Goyal