MIME-Version: 1.0
References: 
 <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
In-Reply-To: 
 <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
From: Zaid Shabbir <zaidshabbir@gmail.com>
Date: Tue, 8 Oct 2024 14:54:21 +0500
Message-ID: 
 <CABCJe_XHiuK07Q1oYyq1ZjGMUrCkvonDSfzL0nY3RqSP-U72vw@mail.gmail.com>
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
To: Sameer Malve <malvesameer@gmail.com>
Cc: pgsql-admin@lists.postgresql.org, Sameer.Malve@mobileum.com
Content-Type: multipart/alternative; boundary="000000000000c89dfe0623f41fda"
Archived-At: 
 <https://www.postgresql.org/message-id/CABCJe_XHiuK07Q1oYyq1ZjGMUrCkvonDSfzL0nY3RqSP-U72vw%40mail.gmail.com>
Precedence: bulk

--000000000000c89dfe0623f41fda
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM 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
>

--000000000000c89dfe0623f41fda
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello=C2=A0Sameer,<div><br></div><div>For upgrade you can =
also use quick upgrade scripts</div><div><br></div><div><p style=3D"margin:=
0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo=
;color:rgb(0,0,0)"><span style=3D"font-variant-ligatures:no-common-ligature=
s">/usr/pgsql-16/bin/postgresql-16-setup check_upgrade</span></p><p style=
=3D"margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-f=
amily:Menlo;color:rgb(0,0,0)"><span style=3D"font-variant-ligatures:no-comm=
on-ligatures"></span></p><p style=3D"margin:0px;font-stretch:normal;font-si=
ze:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style=
=3D"font-variant-ligatures:no-common-ligatures">/usr/pgsql-16/bin/postgresq=
l-16-setup upgrade</span></p><p style=3D"margin:0px;font-stretch:normal;fon=
t-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span st=
yle=3D"font-variant-ligatures:no-common-ligatures"><br></span></p><p style=
=3D"margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-f=
amily:Menlo;color:rgb(0,0,0)">Above commands are helpful to upgrade from 15=
 to 16, in case someone wants to upgrade from -2 older version then some mi=
nor adjustments required in setup script.</p><p style=3D"margin:0px;font-st=
retch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(=
0,0,0)"><span style=3D"font-variant-ligatures:no-common-ligatures"><br></sp=
an></p><p style=3D"margin:0px;font-stretch:normal;font-size:11px;line-heigh=
t:normal;font-family:Menlo;color:rgb(0,0,0)"><span style=3D"font-variant-li=
gatures:no-common-ligatures"><br></span></p><p style=3D"margin:0px;font-str=
etch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0=
,0,0)"><span style=3D"font-variant-ligatures:no-common-ligatures">Regards,<=
/span></p><p style=3D"margin:0px;font-stretch:normal;font-size:11px;line-he=
ight:normal;font-family:Menlo;color:rgb(0,0,0)"><span style=3D"font-variant=
-ligatures:no-common-ligatures">Zaid</span></p></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Oct 8, 2024 =
at 1:24=E2=80=AFPM Sameer Malve &lt;<a href=3D"mailto:malvesameer@gmail.com=
">malvesameer@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-=
style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr">Hi Team,<div><br></div><div>We are trying to perform the Major ver=
sion upgrade on RHEL 8 using RHEL-certified repo `rhel-8-for-x86_64-appstre=
am-rpms` from PG 15.6 to PG 16.4 using `pg_upgrade` but we are facing the b=
elow issue.</div><div><br></div><div>As the binaries are getting upgraded i=
n-place `/usr/bin` hence=C2=A0while performing pg_upgrade we are not gettin=
g the older binaries.</div><div><br></div><div>pg_upgrade command is as fol=
lows.</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-lef=
t-color:rgb(204,204,204);padding-left:1ex">[2024-10-04 11:18:47]=C2=A0 $ /u=
sr/bin/pg_upgrade -b /usr/bin/ -B /usr/bin/ -d /pgData/pgsql/15/data -D /pg=
Data/pgsql/16/data -c<br>[2024-10-04 11:19:19] =C2=A0<br>[2024-10-04 11:19:=
19] =C2=A0You must identify the directory where the old cluster binaries re=
side.<br>[2024-10-04 11:19:19] =C2=A0Please use the -b command-line option =
or the PGBINOLD environment variable.<br>[2024-10-04 11:19:19] =C2=A0Failur=
e, exiting<br></blockquote><div>=C2=A0</div><div><br></div><div>Regards,</d=
iv><div>Sameer Malve</div></div>
</blockquote></div>

--000000000000c89dfe0623f41fda--