From: | Gautham Raj <gauthamrajsunny(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Multiple Postgrest Verisons how to set one version as default. |
Date: | 2023-04-29 12:28:39 |
Message-ID: | CAHByZMBDee03zvx6v=irzAfbtz_p=METeDWPcr27e+D60P-h9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
[image: 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
Tried updating the PATH variable correctly with the latest version. But not
working.
[image: Screenshot from 2023-04-28 21-28-44.png]
Please share the steps or any guidance on how to resolve the issue.
Thank you so much. Anything would be helpful.
Thanks & Regards,
Gautham
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2023-04-29 14:05:48 | Re: Multiple Postgrest Verisons how to set one version as default. |
Previous Message | Bruce Momjian | 2023-04-28 20:08:34 | Re: HOT update: why must ALL indexes should be update? |