Re: [HACKERS] Runing DBT2 on Postgresql

2014-05-12 Thread Rohit Goyal
On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan p...@heroku.com wrote:

 On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal rhtgyl...@gmail.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


Re: [HACKERS] Runing DBT2 on Postgresql

2014-04-24 Thread Rohit Goyal
Hi Peter/All,

Can you please elaborate a bit in details the steps? where are how to run
these steps?

Regards,
Rohit Goyal


On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan p...@heroku.com wrote:

 On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal rhtgyl...@gmail.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




-- 
Regards,
Rohit Goyal


Re: [HACKERS] Runing DBT2 on Postgresql

2014-04-24 Thread Rohit Goyal
Hi Everyone,

Sorry, i got this now. :)

Regards,
Rohit Goyal


On Thu, Apr 24, 2014 at 4:24 PM, Rohit Goyal rhtgyl...@gmail.com wrote:

 Hi Peter/All,

 Can you please elaborate a bit in details the steps? where are how to run
 these steps?

 Regards,
 Rohit Goyal


 On Thu, Apr 24, 2014 at 6:57 AM, Peter Geoghegan p...@heroku.com wrote:

 On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal rhtgyl...@gmail.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




 --
 Regards,
 Rohit Goyal




-- 
Regards,
Rohit Goyal


Re: [HACKERS] Runing DBT2 on Postgresql

2014-04-23 Thread Peter Geoghegan
On Wed, Apr 23, 2014 at 2:33 AM, Rohit Goyal rhtgyl...@gmail.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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers