To: "ktm@rice.edu" <ktm@rice.edu>
cc: bobbyw <bobbyw@sendprobe.com>, pgsql-performance@postgresql.org
Subject: Re: DBT-5 & Postgres 9.0.3 
In-reply-to: <20110817181406.GI26302@staff-mud-56-27.rice.edu> 
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>
	<4E4BFA2B.60507@squeakycode.net>
	<1313603952652-4709231.post@n5.nabble.com>
	<20110817181406.GI26302@staff-mud-56-27.rice.edu>
Comments: In-reply-to "ktm@rice.edu" <ktm@rice.edu>
	message dated "Wed, 17 Aug 2011 13:14:06 -0500"
Date: Wed, 17 Aug 2011 16:12:25 -0400
Message-ID: <322.1313611945@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"ktm@rice.edu" <ktm@rice.edu> writes:
> On Wed, Aug 17, 2011 at 10:59:12AM -0700, bobbyw wrote:
>> Why is psql looking in /tmp?

> Because that is the default location. If you want to change it, you need
> to use the -h commandline option.

It sounds to me like bobbyw might have two separate installations of
postgres (or at least two copies of psql), one compiled with /tmp as the
default socket location and one compiled with /var/run/postgresql as the
default.  /tmp is the out-of-the-box default but I think Debian likes to
build it with /var/run/postgresql as the default.

			regards, tom lane