In linux run “which psql” to see which version is used to connect
Sent from my iPhone
On Feb 14, 2020, at 01:11, Jeff Janes <jeff.janes@gmail.com> wrote:
On Thu, Feb 13, 2020 at 11:23 AM Murali Paramu <ipmurali@gmail.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 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.