Re: could not connect via psql to 9.4 version

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Thu, Feb 13, 2020 at 11:23 AM Murali Paramu <ipmurali@xxxxxxxxx> 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 5432
psql: 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