pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Aidan Van Dyk <aidan@highrise.ca>
Cc: ktm@rice.edu <ktm@rice.edu>
Cc: bobbyw <bobbyw@sendprobe.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DBT-5 & Postgres 9.0.3
Date: Wed, 17 Aug 2011 17:17:11 -0400
Message-ID: <4624.1313615831@sss.pgh.pa.us> (raw)
In-Reply-To: <CAC_2qU8h4eitU09dn=B3gPUOAK9Q_v3n9n=UTAGPTFfOEqAxgg@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>
	<1313594994243-4708692.post@n5.nabble.com>
	<4E4BFA2B.60507@squeakycode.net>
	<1313603952652-4709231.post@n5.nabble.com>
	<20110817181406.GI26302@staff-mud-56-27.rice.edu>
	<322.1313611945@sss.pgh.pa.us>
	<CAC_2qU8h4eitU09dn=B3gPUOAK9Q_v3n9n=UTAGPTFfOEqAxgg@mail.gmail.com>

Aidan Van Dyk <aidan@highrise.ca> writes:
> On Wed, Aug 17, 2011 at 4:12 PM, Tom Lane <tgl@sss.pgh.pa.us> 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



view thread (12+ messages)  latest in thread

Message-ID: <4624.1313615831@sss.pgh.pa.us>
Permalink:  ../4624.1313615831@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/4624.1313615831@sss.pgh.pa.us

 · 

reply
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: tgl@sss.pgh.pa.us, aidan@highrise.ca, ktm@rice.edu, bobbyw@sendprobe.com
  Subject: Re: DBT-5 & Postgres 9.0.3
  In-Reply-To: <4624.1313615831@sss.pgh.pa.us>

* 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