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

From: Gautham Raj <gauthamrajsunny(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Postgres Version want to update from 9.2 to 9.5 version in CentOS 7.9
Date: 2023-04-28 16:03:26
Message-ID: CAHByZMCa4JHJNcZ24rJ_Y3fRBi0=J9XvGNym1hMjFbRzHGWgVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
[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.

Thankyou so much. Anything would be helpful.

Thanks & Regards,
Gautham

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Borisov 2023-04-28 16:29:21 Re: Possible regression setting GUCs on \connect
Previous Message Eric Ridge 2023-04-28 14:03:13 Re: [PATCH] Support % wildcard in extension upgrade filenames