Re: Connection Issue

Hi,

On Fri, Jun 12, 2009 at 12:19 PM, Kevin
Kempter<kevink@consistentstate.com> wrote:
> unix_socket_directory = '/var/run/postgresql' # (change requires restart)
<snip>
> I can ssh to a different host and connect via psql -h <host>
>
> but if I'm on the postgres local server I get this:
>
> $ psql -l
> psql: 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"?
>
>
> Thoughts?

You need to specify the directory of unix-domain socket as follows.

   $ psql -h /var/run/postgresql -l

HTH

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center