From: bobbyw <bobbyw@sendprobe.com>
To: pgsql-performance@postgresql.org
Subject: Re: DBT-5 & Postgres 9.0.3
Date: Wed, 17 Aug 2011 08:29:54 -0700 (PDT)
Message-ID: <1313594994243-4708692.post@n5.nabble.com> (raw)
In-Reply-To: <BANLkTimGW8b=8ogqgf48T1FV9ea74P_m5Q@mail.gmail.com>
References: <BANLkTiku1VaSVqQFt_uuHcyS3uc0NyJW6g@mail.gmail.com>
<BANLkTimmvCDjYGMqm_BaxwvPULyNFXVuVw@mail.gmail.com>
<BANLkTin+B4EQPHMqvvfS2uXG4jF7r+ZMNg@mail.gmail.com>
<BANLkTimGW8b=8ogqgf48T1FV9ea74P_m5Q@mail.gmail.com>
Hi, I know this is an old thread, but I wanted to chime in since I am having
problems with this as well.
I too am trying to run dbt5 against Postgres. Specifically I am trying to
run it against Postgres 9.1beta3.
After jumping through many hoops I ultimately was able to build dbt5 on my
debian environment, but when I attempt to run the benchmark with:
dbt5-run-workload -a pgsql -c 5000 -t 5000 -d 60 -u 1 -i ~/dbt5-0.1.0/egen
-f 500 -w 300 -n dbt5 -p 5432 -o /tmp/results
it runs to completion but all of the dbt5 log files contain errors like:
terminate called after throwing an instance of 'pqxx::broken_connection'
what(): could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
I'm lead to believe that this is an error I would receive if the Postgres db
were not running, but it is. In fact, the way dbt5-run-workload works it
starts the database automatically. I have also confirmed it is running by
manually connecting while this benchmark is in progress (and after it has
already started the database and logged the above error).
Any thoughts on why I might be getting this error?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/DBT-5-Postgres-9-0-3-tp4297670p4708692.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bobbyw@sendprobe.com
Subject: Re: DBT-5 & Postgres 9.0.3
In-Reply-To: <1313594994243-4708692.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox