Multiple Postgrest Verisons how to set one version as default.

Поиск
Список
Период
Сортировка
От Gautham Raj
Тема Multiple Postgrest Verisons how to set one version as default.
Дата
Msg-id CAHByZMBDee03zvx6v=irzAfbtz_p=METeDWPcr27e+D60P-h9g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Multiple Postgrest Verisons how to set one version as default.  (Ron <ronljohnsonjr@gmail.com>)
Re: Multiple Postgrest Verisons how to set one version as default.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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. 
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 --enablerepo=centos-sclo-rh -y install rh-postgresql95-postgresql-server

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.

Thank you so much. Anything would be helpful.

Thanks & Regards,
Gautham
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: HOT update: why must ALL indexes should be update?
Следующее
От: Ron
Дата:
Сообщение: Re: Multiple Postgrest Verisons how to set one version as default.