Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

Hello Sameer,

For upgrade you can also use quick upgrade scripts

/usr/pgsql-16/bin/postgresql-16-setup check_upgrade

/usr/pgsql-16/bin/postgresql-16-setup upgrade

Above commands are helpful to upgrade from 15 to 16, in case someone wants
to upgrade from -2 older version then some minor adjustments required in
setup script.

Regards,

Zaid

On Tue, Oct 8, 2024 at 1:24 PM Sameer Malve <malvesameer(at)gmail(dot)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
>