| From: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
|---|---|
| To: | bobbyw <bobbyw(at)sendprobe(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: DBT-5 & Postgres 9.0.3 |
| Date: | 2011-08-17 18:14:06 |
| Message-ID: | 20110817181406.GI26302@staff-mud-56-27.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anish Kejariwal | 2011-08-17 18:20:39 | Calculating statistic via function rather than with query is slowing my query |
| Previous Message | bobbyw | 2011-08-17 17:59:12 | Re: DBT-5 & Postgres 9.0.3 |