Postgres Version want to update from 9.2 to 9.5 version in CentOS 7.9

Поиск
Список
Период
Сортировка
От Gautham Raj
Тема Postgres Version want to update from 9.2 to 9.5 version in CentOS 7.9
Дата
Msg-id CAHByZMCa4JHJNcZ24rJ_Y3fRBi0=J9XvGNym1hMjFbRzHGWgVA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres Version want to update from 9.2 to 9.5 version in CentOS 7.9  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
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.

Thankyou so much. Anything would be helpful.

Thanks & Regards,
Gautham

Вложения

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

Предыдущее
От: Eric Ridge
Дата:
Сообщение: Re: [PATCH] Support % wildcard in extension upgrade filenames
Следующее
От: Pavel Borisov
Дата:
Сообщение: Re: Possible regression setting GUCs on \connect