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)
Ответы: Re: DBT-5 & Postgres 9.0.3  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

DBT-5 & Postgres 9.0.3  (Sethu Prasad, )
 Re: DBT-5 & Postgres 9.0.3  (Robert Haas, )
  Re: DBT-5 & Postgres 9.0.3  (Sethu Prasad, )
   Re: DBT-5 & Postgres 9.0.3  (Robert Haas, )
    Re: DBT-5 & Postgres 9.0.3  (bobbyw, )
     Re: DBT-5 & Postgres 9.0.3  (Andy Colson, )
      Re: DBT-5 & Postgres 9.0.3  (bobbyw, )
       Re: DBT-5 & Postgres 9.0.3  ("", )
        Re: DBT-5 & Postgres 9.0.3  (Tom Lane, )
         Re: DBT-5 & Postgres 9.0.3  (Aidan Van Dyk, )
          Re: DBT-5 & Postgres 9.0.3  (Tom Lane, )
     Re: DBT-5 & Postgres 9.0.3  (Mark Wong, )

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 по дате сообщения:

От: Craig Ringer
Дата:
Сообщение: Re: Calculating statistic via function rather than with query is slowing my query
От: "mark"
Дата:
Сообщение: Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++