Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

Поиск
Список
Период
Сортировка
От Sameer Malve
Тема Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Дата
Msg-id CAEGp0dhk8ZV_jD1guT8G9qKWtu4_1+Y3eTY0dLCD7psAYfN5iA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.  (obi reddy <obireddy.g1997@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi Obi,

Just to update you, we are  not using the PGDG community that provides Postgres. 

And the major difference between the PGDG community provided Postgres and RHEL provided Postgres is the binary files are installed in different location.

in PGDG Postgres it is installed under `/usr/pgsql-16/bin` whereas in RHEL Postgres it gets installed under `/usr/bin`.

hence we can't use the command you suggested.

Regards,
Sameer Malve. 



On Tue, Oct 8, 2024 at 2:02 PM obi reddy <obireddy.g1997@gmail.com> wrote:
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 по дате отправления: