Upgrade postgres 11 to 15 and postgis 2.5 to 3.3

From: Herman Anker <herman(dot)anker1(at)uwaterloo(dot)ca>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Upgrade postgres 11 to 15 and postgis 2.5 to 3.3
Date: 2024-01-10 20:08:27
Message-ID: YTBPR01MB36147E56A32A61BFAFC194A1CB692@YTBPR01MB3614.CANPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

I would like some pointers of how to go about this.
My prod server runs centos 8.2 and is obviously out of any support.
So I decided to install redhat 8.4 with license on a server dedicated for this conversion.
Soon after I realize that postgres 11 and postgis 2.5 is no longer obtainable to be installed from Postgres.
I realized soon that:

* Postgres 11 seems easy to obtain from unsupported archive sites. Have not tested install yet. May not be 100% good.
* Postgis 2.5 with all dependant packages is not obtainable from unsupported archive sites.

Looking at this from above, what do I do here? I cannot be the only one facing this dead end road, right?
So far my effort have been on Redhat Linux.
Are there other Linux variants where this conversion can take place easily?
Since this is a just a conversion, Im open to even get this done on Windows.

What would be good plan here?

Best,
Herman

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message P C 2024-01-11 06:00:17 Synchronous Replication: Where is data visible first?
Previous Message Sbob 2024-01-10 19:15:56 SOLVED: Re: Error: Failed to download metadata for repo 'pgdg16': repomd.xml GPG signature verification error: Signing key not found