Re: RHEL certified repo provided PostgreSQL Major Version Upgrade. - Mailing list pgsql-admin

From obi reddy
Subject Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Date
Msg-id CAO7L2ZyB8j3EuOF1-jiMb5jzxvhxqLa1pK1viuP0az1QNf8VsQ@mail.gmail.com
Whole thread Raw
In response to RHEL certified repo provided PostgreSQL Major Version Upgrade.  (Sameer Malve <malvesameer@gmail.com>)
Responses Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
List pgsql-admin
Hi Sameer,

Please try with this command.

/usr/bin/pg_upgrade -b /usr/pgsql-15/bin/ -B /usr/pgsql-16/bin/ -d /pgData/pgsql/15/data -D /pgData/pgsql/16/data -c

If above command is not working check the below one.

/usr/pgsql-16/bin/pg_upgrade -b /usr/pgsql-15/bin/ -B /usr/pgsql-16/bin/ -d /pgData/pgsql/15/data -D /pgData/pgsql/16/data -c

Thanks & Regards
Obireddy



On Tue, 8 Oct 2024, 13:54 Sameer Malve, <malvesameer@gmail.com> wrote:
Hi Team,

We are trying to perform the Major version upgrade on RHEL 8 using RHEL-certified repo `rhel-8-for-x86_64-appstream-rpms` from PG 15.6 to PG 16.4 using `pg_upgrade` but we are facing the below issue.

As the binaries are getting upgraded in-place `/usr/bin` hence while performing pg_upgrade we are not getting the older binaries.

pg_upgrade command is as follows.

[2024-10-04 11:18:47]  $ /usr/bin/pg_upgrade -b /usr/bin/ -B /usr/bin/ -d /pgData/pgsql/15/data -D /pgData/pgsql/16/data -c
[2024-10-04 11:19:19]  
[2024-10-04 11:19:19]  You must identify the directory where the old cluster binaries reside.
[2024-10-04 11:19:19]  Please use the -b command-line option or the PGBINOLD environment variable.
[2024-10-04 11:19:19]  Failure, exiting
 

Regards,
Sameer Malve

pgsql-admin by date:

Previous
From: Sameer Malve
Date:
Subject: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Next
From: Zaid Shabbir
Date:
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.