Re: could not connect via psql to 9.4 version

On Thu, Feb 13, 2020 at 11:23 AM Murali Paramu <ipmurali(at)gmail(dot)com> wrote:

> Hello Team,
> I have two versions of PostgreSQL 9.4 and 12.1
> both servers can be connected through pgAdmin.
> But through psql I can connect only to 12.1
>
> when i connect to 9.4 got below error:
>
>
>
>
> *$ psql -U postgres -p 5432psql: error: could not connect to server: 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"?*
>
>
Perhaps 9.4 is configured to put its socket file in /tmp instead of
/var/run/postgresql/. You can try -h /tmp, or you can just always use -h
127.0.0.1, then you don't need to worry where the socket file is.

Cheers,

Jeff