I have 2 different major versions of postgres 9 and 10 installed on rhel.
Latest situation after attempts of updating psql package: I have psql 9.2.24 installed on rhel 7.6 while the server version is 10.7. I had earlier issues with my yum repo which got corrupted and later on, i recovered/fixed it with the help of following command mentioned at here (You can get idea of what my problem was initially with corrupt yum repo)
echo 7 > /etc/yum/vars/releasever
I checked my update-alternatives at here and it is correctly referring to the psql at 10.7 directory but still I am seeing the psql old version number while connecting to existing database.
Following was the steps i followed to update the psql package:
- All databases were kept running.
- yum install postgresql10.x86_64
- Command mentioned in point 2, installed/upgraded whole lot of packages on machine as the yum repo was corrupted . one of the key statements in this upgrade concerning to postgres was
postgresql10 x86_64 10.7-2PGDG.rhel7 pgdg10 1.6M
Please note, I have not yet restarted any of the instance running during/before/after above update and somehow believe it has something related to the fact that until I restart(stop existing instances and start them again) all running instances of psql/db's , psql changes will not start reflecting but that is just my assumption. Could someone please help what i understood/did wrong in this upgrade process.
Nothing except above has been changed/upgraded in terms of psql/postgres. Still I have both installations of postgres: 9 and 10.