Thread: Minor Upgrade Question

Minor Upgrade Question

From
Susan Joseph
Date:
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

Re: Minor Upgrade Question

From
Joshua Drake
Date:
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 <sandajoseph@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

Re: Minor Upgrade Question

From
Susan Joseph
Date:

OK I will try that, thanks

On 6/17/2020 11:19 AM, Joshua Drake wrote:
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 <sandajoseph@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