From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Steve Clark <steve(dot)clark(at)netwolves(dot)com>, pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: psql - looking in wrong place for socket |
Date: | 2017-03-17 13:49:25 |
Message-ID: | 84183321-aa0c-4de3-9b3e-18ba294a1959@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/17/2017 06:42 AM, Steve Clark wrote:
> Hi List,
>
> I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a long time
> then I rebooted. Postgres came up but when I tried to connect with psql on the local machine
> I got
>
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>
> The socket is actually being created (and always has been) in /tmp
So you built Postgres from source?
>
> I worked around the problem temporarily by
> ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432
>
> What controls where psql looks for the socket?
https://www.postgresql.org/message-id/23876.1488949292%40sss.pgh.pa.us
"With the default configure options you used, the postmaster would have
put its Unix socket file into /tmp, not /var/run. I wonder whether your
problem is that you're trying to connect to it with distro-supplied
psql+libpq that expects to find the Unix socket in /var/run."
>
> Thanks,
> Steve
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom DalPozzo | 2017-03-17 14:04:30 | array of bytea; |
Previous Message | Steve Clark | 2017-03-17 13:42:31 | psql - looking in wrong place for socket |