From: | Murali Paramu <ipmurali(at)gmail(dot)com> |
---|---|
To: | abbas alizadeh <ramkly(at)yahoo(dot)com> |
Cc: | Jeff Janes <jeff(dot)janes(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-15 14:45:26 |
Message-ID: | CAC9RKdOGkzHF4PuE_mpEex5fFzugiQGNV-jyPd-SE3SRYN3pmQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you all guys for the help...
when i use right psql it connected.
/opt/PostgreSQL/9.4/bin$ /opt/PostgreSQL/9.4/bin/psql -U postgres
On Fri, Feb 14, 2020 at 3:22 PM abbas alizadeh <ramkly(at)yahoo(dot)com> wrote:
> 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 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
>
>
--
~~~~~~~~~~~~~
സ്നേഹാദരങ്ങളോടെ
ഐ.പി.മുരളി
thanks & regards,
i.p.murali
From | Date | Subject | |
---|---|---|---|
Next Message | Ilko Iliev | 2020-02-16 06:58:21 | pgadmin webapp openID integration |
Previous Message | Deaderick, David | 2020-02-14 19:31:43 | Setting Up pgAdmin4 on Red Hat Enterprise Linux 7 with FIPS Mode Enabled |