Have you checked the local settings in the pg_hba.conf as this will affect permitted access. You can compare what is set differently between the different versions of postgreSQL. Cheers Peter On 2/13/2020 at 5:11 PM, "Jeff Janes" <jeff.janes@xxxxxxxxx> wrote: > >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 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
