Re: DBT-5 & Postgres 9.0.3

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