Aidan Van Dyk <aidan@xxxxxxxxxxx> writes: > On Wed, Aug 17, 2011 at 4:12 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> 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. > It looked like the actual DBT-5 harness is built with "system > libraries" (libpqxx, linked to system libpq, with debian's > /var/run/postgresql), but the scaffolding around it uses a "local" > postgres (server and psql) using the source default of /tmp? Hmm ... doesn't sound like an amazingly good idea. But if DBT wants to do it that way, it'd be well advised to not assume that the system libraries have either the port number or socket directory defaulting to what it is using. Or maybe the problem is that it does override all that stuff and works fine by itself, but then you can't easily connect to the server manually? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance