pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Multiple Postgrest Verisons how to set one version as default.
Date: Sat, 29 Apr 2023 09:05:48 -0500
Message-ID: <f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com> (raw)
In-Reply-To: <CAHByZMBDee03zvx6v=irzAfbtz_p=METeDWPcr27e+D60P-h9g@mail.gmail.com>
References: <CAHByZMBDee03zvx6v=irzAfbtz_p=METeDWPcr27e+D60P-h9g@mail.gmail.com>

On 4/29/23 07:28, Gautham Raj wrote:
> Hi,
>
> *Problem: Having multiple versions of Postgres installed in CentOS 7. I 
> Want to set the 9.5 version as default. Not able to access Postgres 9.5 
> through the terminal as well.*
>
>  1. For Command *psql --version* I'm getting 9.5 as the version.
>  2. For Command *sudo -u postgres psql *I'm getting 9.2 as the version.
>
> Please look at the below screenshot.
> Screenshot from 2023-04-28 21-14-29.png
>
> *Background: *By default, the server has a 9.2 version I installed the 
> *rh-postgresql95* version from the below article.
> Used the below command to install *rh-postgresql95*
>
>     yum
>     <https://www.server-world.info/en/command/html/yum.html> --enablerepo=centos-sclo-rh
>     -y install rh-postgresql95-postgresql-server
>
> https://www.server-world.info/en/note?os=CentOS_7&p=postgresql95&f=1 
> <https://www.server-world.info/en/note?os=CentOS_7&p=postgresql95&f=1;
>
> Tried updating the PATH variable correctly with the latest version. But 
> not working.
>
> Screenshot from 2023-04-28 21-28-44.png
>
>
> Please share the steps or any guidance on how to resolve the issue.

Are you absolutely 100% sure that /opt/rh//rh-postgresql95/root/usr/bin/psql 
is the correct path?

If nothing else, that looks looks like a filename, not a path. I think you 
should remove "/psql" from the *path*.

-- 
Born in Arizona, moved to Babylonia.

Attachments:

Screenshot from 2023-04-28 21-14-29.png (image/png, 29.7K) download view image
Screenshot from 2023-04-28 21-28-44.png (image/png, 24.7K) download view image

view thread (3+ messages)  latest in thread

Message-ID: <f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com>
Permalink:  ../f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com/
Also on:    postgresql.org/message-id/f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: Multiple Postgrest Verisons how to set one version as default.
  In-Reply-To: <f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com>
  References: <CAHByZMBDee03zvx6v=irzAfbtz_p=METeDWPcr27e+D60P-h9g@mail.gmail.com> <f800de1f-a11d-7f9c-641b-34c10e15dd5c@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox