Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

Поиск
Список
Период
Сортировка
От obi reddy
Тема Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Дата
Msg-id CAO7L2ZyB8j3EuOF1-jiMb5jzxvhxqLa1pK1viuP0az1QNf8VsQ@mail.gmail.com
обсуждение исходный текст
Ответ на RHEL certified repo provided PostgreSQL Major Version Upgrade.  (Sameer Malve <malvesameer@gmail.com>)
Ответы Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Список pgsql-admin
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@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

В списке pgsql-admin по дате отправления: