Re: DBT-5 & Postgres 9.0.3 - Mailing list pgsql-performance

From ktm@rice.edu
Subject Re: DBT-5 & Postgres 9.0.3
Date
Msg-id 20110817181406.GI26302@staff-mud-56-27.rice.edu
Whole thread Raw
In response to Re: DBT-5 & Postgres 9.0.3  (bobbyw <bobbyw@sendprobe.com>)
Responses Re: DBT-5 & Postgres 9.0.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Wed, Aug 17, 2011 at 10:59:12AM -0700, bobbyw wrote:
> Awesome.. that did it!  It was actually not set at all in postgresql.conf,
> although it was commented out as:
>
> # unix_socket_directory = ''
>
> Presumably it was using the default of '/tmp'?
>
> Anyway, after making that change dbt5 runs fine, but now when I try to
> connect via "psql" I get:
>
> psql.bin: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> 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.

Regards,
Ken

pgsql-performance by date:

Previous
From: bobbyw
Date:
Subject: Re: DBT-5 & Postgres 9.0.3
Next
From: Anish Kejariwal
Date:
Subject: Calculating statistic via function rather than with query is slowing my query