Susan You can use -Uvh to upgrade the rpms on the existing machine. You can then use symlinks to link the expected pgsql data directories. Make sure you take a backup, and stop the service before you proceed.
JD On Tue, Jun 16, 2020 at 7:12 AM Susan Joseph <sandajos...@verizon.net> wrote: > So when I first started working with PostgreSQL I was using the latest > version (11.2). I don't want to move to 12 yet but I would like to get my > 11.2 up to 11.8. Due to my servers not being connected to the Internet I > ended up downloading the libraries and building the files locally. My > question is how do I upgrade to 11.8? I know how to go and get the rpms > now and download those to a disconnected server and then install PostgreSQL > that way. I was able to install 11.8 on another server using the rpms. > But my directories are different. The rpm install placed the files into > the directory /data/pgsql-11. My 11.2 database is in /data/pgsql. I > checked the rpm file and it says that the files are not relocatable. So I > can do a new install of 11.8 via the rpms and it will place the files into > /data/pgsql-11, can just need to copy the executable files in the > /data/pgsql-11/bin directory into my /data/pgsql/bin or are there other > files that need to be copied over? Is there a better way to do this rather > than reinstalling postgreSQL again on a server that already has it? > > Thanks, > Susan >
