Re: Multiple Postgrest Verisons how to set one version as default.

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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. 

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

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.

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.