From: | Joshua Drake <jd(at)commandprompt(dot)com> |
---|---|
To: | Susan Joseph <sandajoseph(at)verizon(dot)net> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Minor Upgrade Question |
Date: | 2020-06-17 15:19:35 |
Message-ID: | CAJvJg-SCxcgj50X5cR-677YzAMdiYf9s2YiD6oqOUU5iq-fXbw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)verizon(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Drake | 2020-06-17 15:27:22 | Re: Logical replication |
Previous Message | Tom Lane | 2020-06-17 15:18:21 | Re: Importing a Large .ndjson file |