Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

Hi Zaid,

Does this Upgrade command stand true in case of postgres upgrade between
community (PGDG) to RHEL?

Regards,
Sameer Malve

On Tue, Oct 8, 2024 at 3:24 PM Zaid Shabbir <zaidshabbir(at)gmail(dot)com> wrote:

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