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

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