| From: | Susan Joseph <sandajoseph(at)verizon(dot)net> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Minor Upgrade Question |
| Date: | 2020-06-16 14:12:04 |
| Message-ID: | 1526633448.1619840.1592316724992@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Tom Lane | 2020-06-16 14:12:18 | Re: pg_repack: WARNING: relation must have a primary key or not-null unique keys |
| Previous Message | Michael Lewis | 2020-06-16 14:08:48 | Re: pg_repack: WARNING: relation must have a primary key or not-null unique keys |