| 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 |