Re: DBT-5 & Postgres 9.0.3

Поиск
Список
Период
Сортировка
От ktm@rice.edu
Тема Re: DBT-5 & Postgres 9.0.3
Дата
Msg-id 20110817181406.GI26302@staff-mud-56-27.rice.edu
обсуждение исходный текст
Ответ на Re: DBT-5 & Postgres 9.0.3  (bobbyw <bobbyw@sendprobe.com>)
Ответы Re: DBT-5 & Postgres 9.0.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: bobbyw
Дата:
Сообщение: Re: DBT-5 & Postgres 9.0.3
Следующее
От: Anish Kejariwal
Дата:
Сообщение: Calculating statistic via function rather than with query is slowing my query