Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

TeamAs suggested from old server, post shutdown of DB, I did OS level dump of PG_DATA folder and had restored in the new server.
Any idea on how to install the older binary postgres 13.18 ( OS=Amazon Linux 2023.6.20241121) under a dedicated folder suffixed as the following e.g.) /usr/pgsql1318
System Admin had already installed newer version pgsql 15.08 binaries in the  new server (OS= Amazon Linux 2023.6.20241121) in the folder "/usr/bin/"

We were quoted , OS = Amazon Linux 2023.6.20241121 doesnot support postgres ver 15.10 (Community edition) under its AWS-EC2.
Regards

On Wednesday, December 4, 2024 at 12:04:47 PM EST, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

On 12/4/24 04:42, Bharani SV-forum wrote:
> Team /Ron/Adrian
>
> Wann to reconfirm
> we have an setup with
>
> new server will be with
>
> will be following the following suggestion
>
> *On old VM* [ existing server with OS "Amazon Linux release 2 (Karoo) "
> present in aws "us-east-1 region" and along with postgresql ver 13.16.2 
> - community edn ]
>
>   - "take offline full backup (PG_DATA folder alone)  using OS command"
>
> *On new VM [OS "Amazon Linux 2023 " in aws region=us-east-1 and intended
> db as "postgresql 15.10 - community edn" ] *
>
>   - "Restore offline full backup (PG_DATA folder alone) using OS command"
> - create postgres unix userid
> - install postgresql ver 15.10 binaries
> - setup respective env variable to point correctly for PG_DATA
> - will follow "pg_upgrade"

That will not work as you would need an install of Postgres 13 on the
new machine as well. And then there is the issue that the OS version
changed as well. That would cause issues. Follow the process Greg Sabino
Mullane posted.

>
>
> my question is
> a) is the above said steps is correct with the given existing and
> proposed setup
> b) is their any known issues using "cross over using pg_upgrade " option
> between the server's having below said operating system
> *- source = existing server with OS = *Amazon Linux release 2 (Karoo) "
> present in aws "us-east-1 region" and along with postgresql ver 13.16.2 
> - community edn
> vs
> target - different server *OS "Amazon Linux 2023 " in aws
> region=us-east-1 and intended db as "postgresql 15.10 - community edn"*
> *
> *
> *
> *
> On Tuesday, December 3, 2024 at 12:28:58 AM EST, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>
> On 12/2/24 17:23, Ron Johnson wrote:
>  > Adrian,
>  >
>  > OP is moving to a new VM when migrating to PG 15.  When was the
>  > "cross-server" feature added to pg_upgrade?
>  >
>
> Moving to a new VM was not the issue, my mistake was thinking the OS
> version was staying the same.
>
> Then:
>
> On old VM:
>
> "take offline full backup (PG_DATA folder alone)  using OS command"
>
> On new VM:
> "Restore offline full backup (PG_DATA folder alone) using OS command"
>
> Followed by installing new Postgres version could be dealt with using
> pg_upgrade. Once I was corrected on what was actually going on then
> doing a dump/restore or logical replication became better choices.
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com