public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sameer Malve <[email protected]>
To: obi reddy <[email protected]>
Cc: pgsql-admin <[email protected]>
Cc: [email protected]
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Date: Tue, 8 Oct 2024 15:55:44 +0530
Message-ID: <CAEGp0dhk8ZV_jD1guT8G9qKWtu4_1+Y3eTY0dLCD7psAYfN5iA@mail.gmail.com> (raw)
In-Reply-To: <CAO7L2ZyB8j3EuOF1-jiMb5jzxvhxqLa1pK1viuP0az1QNf8VsQ@mail.gmail.com>
References: <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
<CAO7L2ZyB8j3EuOF1-jiMb5jzxvhxqLa1pK1viuP0az1QNf8VsQ@mail.gmail.com>
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 <[email protected]> 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, <[email protected]> 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
>>
>
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
In-Reply-To: <CAEGp0dhk8ZV_jD1guT8G9qKWtu4_1+Y3eTY0dLCD7psAYfN5iA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox