From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Connection Issue |
Date: | 2009-06-12 03:47:29 |
Message-ID: | 3f0b79eb0906112047i1a531cc5k5be429b04f5ce58d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
On Fri, Jun 12, 2009 at 12:19 PM, Kevin
Kempter<kevink(at)consistentstate(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Iñigo Martinez Lasala | 2009-06-12 08:09:13 | Re: Sobre Actualizacion/upgrading PostgreSQL |
Previous Message | Kevin Kempter | 2009-06-12 03:19:16 | Connection Issue |