From: Sameer Malve <Sameer.Malve@mobileum.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Sameer Malve <malvesameer@gmail.com>
CC: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Thread-Topic: RHEL certified repo provided PostgreSQL Major Version Upgrade.
Thread-Index: AQHbGVt85g4qdRaWf06EOC07tnLA8bJ83g2AgAAEOpM=
Date: Tue, 8 Oct 2024 14:02:00 +0000
Message-ID: 
 <PH0PR14MB520943781088094A05AA3244FD7E2@PH0PR14MB5209.namprd14.prod.outlook.com>
References: 
 <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
 <1910788.1728395149@sss.pgh.pa.us>
In-Reply-To: <1910788.1728395149@sss.pgh.pa.us>
Accept-Language: en-US, en-IN
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?aBgMTlulDWgh0i7fVnBl03Cp4qIiy6INcwpQ3hpu07wXpwq9S1WAiwoa8rIp?=
 =?us-ascii?Q?dKqliDMNmUNGCqkwkYHG2iHdmuK5OeIdHmH3LzCsDSKLg2gLkIOMRHPDMSAn?=
 =?us-ascii?Q?eXh3CK6gMUgVvuzt/TaxzbEAhoY18cYuFvB6a7VrhvJv2jgXt6TxuNsVwMJs?=
 =?us-ascii?Q?XExBLWa+7N6RZiPFtPjH7Am/Rk7gmeS2TppBxXbMzC/ZNmjk/DmtG9Xx5Ny+?=
 =?us-ascii?Q?U11IMP0Q8Hi5WI6Dt/7bNeIavWnpGmRQ02J6aH11skdHt9y7KZ1XOrEpwuBl?=
 =?us-ascii?Q?OzVpkwcZTNAn2xIMXpMFvhTO74qj1qYZHGPVci6LOdCgKvNFQYzbnMEZE8cF?=
 =?us-ascii?Q?oMeS0PKaEdPjuUe/MMymKsFxcQYDS6oToBUMcv/EpZ+inaT43wzeFTARK+7p?=
 =?us-ascii?Q?m7PNMrPmXRE6gTCegtVpT2WTR0ew0vEbmAWzxpYYRBrt9oLjGEsKuMtp+eKq?=
 =?us-ascii?Q?sTGxg4/6QZlmibTxOdeM2uTRdUOqFVk9cASMW2UbEriKvHw1W9+AfYQvnb7e?=
 =?us-ascii?Q?/Iqv6Drs9nMvD3ZfiM7XdZI9m0Pr1VnmH171dcneceMzXt1n/Rl8OiorW/US?=
 =?us-ascii?Q?3ERWNAmSJ7nZCb46Q80VZBzX4jiiCVsQwGEV8P0/sEiFIUWN6PY388rqgYHW?=
 =?us-ascii?Q?UUTHaIku4+zjuxhxhms9SCA8hK2/0w8cOo4Xi4SRFbPyvqeqSMNU6cv/dcQ8?=
 =?us-ascii?Q?Yun81X8clk9ALrE65s0I+wJpoN6w0TKrWfoDswh7FgmZhwt6UWbw3ZWXumyk?=
 =?us-ascii?Q?R02B1s6uQFrP17UHxQDQDMdyp5bs9y4/udtG9udyMnw27RqcPSJi+4MzlaL/?=
 =?us-ascii?Q?w8mGtaEoIw/DcKmxtdrF7Z/Asop+YbQ6vHmq8ve4u7IVYIyR7tzjoqTzwQyg?=
 =?us-ascii?Q?DbeOEE6UfPvDmr8iAk8fPF2iqjoRySEGX514DvXW+9m0RVywegEK8Nh8bdle?=
 =?us-ascii?Q?RWXPuxlgiJUwxdwpPQAJqjmFgNlJN81N0hNsFnafLxmf88yKxlB1D9cfyzOE?=
 =?us-ascii?Q?FcERlQluXZ9LhOeKRxhjDcF5oeo+qlzz5w+WBg8zVk+gLdAEu9q5xhzufis5?=
 =?us-ascii?Q?rdiWQYDqdEAsL1sUJC7F1t4ZHkEJU2YPW/xCZ5jHVp4WSkZGJAtijR60D+N5?=
 =?us-ascii?Q?3dNNhGeVQXSF3Z2yN4lOT+zZnU/uyIk7IsPovVAyLpgheDvGj+B8+AS7x0YY?=
 =?us-ascii?Q?PeKSPay7qxo97u7Tb+NgMJ9g+rgmOZCQ5+BZO0ASlsGHsn3oe1yEey3zB7aJ?=
 =?us-ascii?Q?lXUBj93/2f5IchAkRaIKofBBSGDhwJvjAceCWYvoW66GojKP6u9lOunhF6c0?=
 =?us-ascii?Q?81m0hMWUmFKpS/yZYLiyZ84UlG8tIXQ4sm22Ml1fMRvd29Tn1Nal8Wmf1PX/?=
 =?us-ascii?Q?IP4RnjCnyrGEUHS5JiPIq7raNDW2zIqiizmX94g51sDoxeqfdDpiIzOjAzU4?=
 =?us-ascii?Q?F1gGTU7uMdlQEVm4ZIOZ0ytf5EMW7mAAbTF+/Plhz9RCuctieKtHntGYJLxu?=
 =?us-ascii?Q?tNa7hl+uMRB4wlKy+qc71cJWYaQk0I99edvlN3JghruEvZWs9c//LXDZVipz?=
 =?us-ascii?Q?y+UXWZCoHGEtEWqtvUTZxoNvNu670fglfKTjI4qvdC4fHYOAm6+oaJKAYYhF?=
 =?us-ascii?Q?p1apQ5mhULNtEIDgjPAjVwI=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH0PR14MB520943781088094A05AA3244FD7E2PH0PR14MB5209namp_"
MIME-Version: 1.0
X-OriginatorOrg: mobileum.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH0PR14MB5209.namprd14.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 3bed0d40-f5eb-4246-6b40-08dce7a1c7c1
X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Oct 2024 14:02:00.6394
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9443e4d1-e994-48df-881d-ee86b584660a
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 QNcclkWn2JwnB7sADcEPWq8e+nDM8xJ3bAfJ+s5gRcUDLyt9oW1mHXa1LxoK9w3NYsZZ7WYLiYHG1mSlqXCqw3pRnLGRAiNKxfjjXpYHLxk=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR14MB4003
X-BESS-ID: 1728396125-105919-12749-6934-1
X-BESS-VER: 2019.1_20241004.2057
X-BESS-Apparent-Source-IP: 104.47.55.47
X-BESS-Parts: H4sIAAAAAAACAzXLMQ7DIBBE0bts7QIYYBdfJUqRZUFuohSmsBT57qEgzehrpP
	f4UrsG7TTmbvQ5afcpxFnHPLMpOidxFa1qYPE9Zi3MrxTQmOne/v4Y7+UDgOXZnEoXkW
	ScY/GuVGg3UxGUBqP7+QNFORIWgQAAAA==
X-BESS-Outbound-Spam-Score: 0.00
X-BESS-Outbound-Spam-Report: Code version 3.2,
 rules version 3.2.2.259584 [from
	cloudscan12-142.us-east-2a.ess.aws.cudaops.com]
	Rule breakdown below
	 pts rule name              description
	---- ---------------------- --------------------------------
	0.00 HTML_MESSAGE           BODY: HTML included in message
	0.00 BSF_BESS_OUTBOUND      META: BESS Outbound
X-BESS-Outbound-Spam-Status: SCORE=0.00 using account:ESS43308 scores of
 KILL_LEVEL=7.0 tests=HTML_MESSAGE, BSF_BESS_OUTBOUND
X-BESS-BRTS-Status: 1
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/PH0PR14MB520943781088094A05AA3244FD7E2%40PH0PR14MB5209.namprd14.prod.outlook.com>
Precedence: bulk

--_000_PH0PR14MB520943781088094A05AA3244FD7E2PH0PR14MB5209namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thanks Tom.  I have installed that upgrade package rpm will go through it a=
nd try. And would let you know incase I get stucked .

Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Tuesday, October 8, 2024 7:15:49 PM
To: Sameer Malve <malvesameer@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; Sa=
meer Malve <Sameer.Malve@mobileum.com>
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.

Caution :External

Sameer Malve <malvesameer@gmail.com> writes:
> 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.

It's been more than ten years since I was responsible for Red Hat's
packaging of PG, but I think I recall that the solution in place for
pg_upgrade involved a separate postgresql-upgrade RPM containing
previous-version executables, which you were supposed to install
alongside the new version for long enough to perform the upgrade.
Whatever the details were, I'm quite certain the package's README file
contained an explanation of how to do it.  Read that, do not pay
attention to people or chatbots telling you how you'd do it with some
other packaging.

                        regards, tom lane

--_000_PH0PR14MB520943781088094A05AA3244FD7E2PH0PR14MB5209namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body>
<div dir=3D"auto">Thanks Tom.&nbsp; I have installed that upgrade package r=
pm will go through it and try. And would let you know incase I get stucked =
.</div>
<div id=3D"ms-outlook-mobile-signature" dir=3D"auto">
<div><br>
</div>
Get <a href=3D"https://aka.ms/AAb9ysg">Outlook for Android</a></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Tom Lane &lt;tgl@sss.=
pgh.pa.us&gt;<br>
<b>Sent:</b> Tuesday, October 8, 2024 7:15:49 PM<br>
<b>To:</b> Sameer Malve &lt;malvesameer@gmail.com&gt;<br>
<b>Cc:</b> pgsql-admin@lists.postgresql.org &lt;pgsql-admin@lists.postgresq=
l.org&gt;; Sameer Malve &lt;Sameer.Malve@mobileum.com&gt;<br>
<b>Subject:</b> Re: RHEL certified repo provided PostgreSQL Major Version U=
pgrade.</font>
<div>&nbsp;</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;=
">
<div class=3D"PlainText">Caution :External<br>
<br>
Sameer Malve &lt;malvesameer@gmail.com&gt; writes:<br>
&gt; We are trying to perform the Major version upgrade on RHEL 8 using<br>
&gt; RHEL-certified repo `rhel-8-for-x86_64-appstream-rpms` from PG 15.6 to=
 PG<br>
&gt; 16.4 using `pg_upgrade` but we are facing the below issue.<br>
&gt; As the binaries are getting upgraded in-place `/usr/bin` hence while<b=
r>
&gt; performing pg_upgrade we are not getting the older binaries.<br>
<br>
It's been more than ten years since I was responsible for Red Hat's<br>
packaging of PG, but I think I recall that the solution in place for<br>
pg_upgrade involved a separate postgresql-upgrade RPM containing<br>
previous-version executables, which you were supposed to install<br>
alongside the new version for long enough to perform the upgrade.<br>
Whatever the details were, I'm quite certain the package's README file<br>
contained an explanation of how to do it.&nbsp; Read that, do not pay<br>
attention to people or chatbots telling you how you'd do it with some<br>
other packaging.<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; regards, to=
m lane<br>
</div>
</span></font></div>
</body>
</html>

--_000_PH0PR14MB520943781088094A05AA3244FD7E2PH0PR14MB5209namp_--