From: Andy Colson <andy@squeakycode.net>
To: bobbyw <bobbyw@sendprobe.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DBT-5 & Postgres 9.0.3
Date: Wed, 17 Aug 2011 12:28:11 -0500
Message-ID: <4E4BFA2B.60507@squeakycode.net> (raw)
In-Reply-To: <1313594994243-4708692.post@n5.nabble.com>
References: <BANLkTiku1VaSVqQFt_uuHcyS3uc0NyJW6g@mail.gmail.com>
<BANLkTimmvCDjYGMqm_BaxwvPULyNFXVuVw@mail.gmail.com>
<BANLkTin+B4EQPHMqvvfS2uXG4jF7r+ZMNg@mail.gmail.com>
<BANLkTimGW8b=8ogqgf48T1FV9ea74P_m5Q@mail.gmail.com>
<1313594994243-4708692.post@n5.nabble.com>
On 8/17/2011 10:29 AM, bobbyw wrote:
> 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.
>
Its trying to connect to unix socket "/var/run/postgresql/.s.PGSQL.5432",
but your postgresql.conf file probably has:
unix_socket_directory = '/tmp'
Change it to:
unix_socket_directory = '/var/run/postgresql'
and restart PG.
-Andy
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: andy@squeakycode.net, bobbyw@sendprobe.com
Subject: Re: DBT-5 & Postgres 9.0.3
In-Reply-To: <4E4BFA2B.60507@squeakycode.net>
* 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