Message-ID: <4E4BFA2B.60507@squeakycode.net>
Date: Wed, 17 Aug 2011 12:28:11 -0500
From: Andy Colson <andy@squeakycode.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: bobbyw <bobbyw@sendprobe.com>
CC: pgsql-performance@postgresql.org
Subject: Re: DBT-5 & Postgres 9.0.3
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>
In-Reply-To: <1313594994243-4708692.post@n5.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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