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@xxxxxxxxx> 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@xxxxxxxxx> 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, exitingRegards,Sameer Malve