I have Postgres db instance 10.6 running in production say node-b: rhel 7.6 while I am building another cluster (not instance) of 2 nodes. Out of these 2 nodes one posgres node will reside on this machine. Somehow other node node-a has postgres 10.7 running there already for some more instances.
Is there a possibility to run 2 postgres minor version, in my case 10.7 and 10.6 on production machine node-b in parallel?
I tried testing it by installing from yum on node-b and found yum will override/change the existing installation. I am afraid it will kill the running postgres and hence did not proceeded further.
Off-course I can first upgrade node-b postgres production instance to 10.7 and then all-together can work on same version 10.7 across cluster but that I keep the last option. It has its own approval and all usual process track attached.
I recollect that it is a possibility to build from code (make,configure,install and ...) of particular version of 10.7 on node-b but I am not sure would it work as the underlying directory under /usr will still be same?