Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

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(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
>