From: | abbas alizadeh <ramkly(at)yahoo(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Murali Paramu <ipmurali(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: could not connect via psql to 9.4 version |
Date: | 2020-02-14 11:22:17 |
Message-ID: | C2947FC7-53C7-496D-8A19-C6A343CDFB78@yahoo.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi.
You should use the right psql for version 9.4.
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(dot)janes(at)gmail(dot)com> wrote:
>
>
>> 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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2020-02-14 13:52:43 | Re: creative work-arounds to obtain auto_explain's benefits for non-superuser |
Previous Message | Rahul Saha | 2020-02-14 05:56:13 | Re: MULTI MASTER IMPLEMENTATION |