Date: Tue, 08 Oct 2024 16:20:10 +0200
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: RHEL certified repo provided PostgreSQL Major Version Upgrade.
User-Agent: K-9 Mail for Android
In-Reply-To: 
 <CAEGp0djRTqRvomPfyem0YGbzjDLSiDjDaob3FPYqTbg-G-T-9g@mail.gmail.com>
References: 
 <CAEGp0dgUL=j4ULDfGz4j=kbv2sAzP5dmp=Wem7cOknq8gyge4Q@mail.gmail.com>
 <CABCJe_XHiuK07Q1oYyq1ZjGMUrCkvonDSfzL0nY3RqSP-U72vw@mail.gmail.com>
 <CAEGp0dhrCdbObZ4OQy_swTdpUEBFAHe-Hf1HdAHCMcYVTaJ2hA@mail.gmail.com>
 <5e25f0ae351c9be37078c9d75cbbfd3993527b4c.camel@cybertec.at>
 <CAEGp0djRTqRvomPfyem0YGbzjDLSiDjDaob3FPYqTbg-G-T-9g@mail.gmail.com>
Message-ID: <DB4856E6-B207-4A0F-AF89-9BD08201706A@jakobs.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary=----0CU5PIMLERLP9VLIKBR2N6Q3S7G8HU
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/DB4856E6-B207-4A0F-AF89-9BD08201706A%40jakobs.com>
Precedence: bulk

------0CU5PIMLERLP9VLIKBR2N6Q3S7G8HU
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

Before installing the new version over the old one, save the binaries and l=
ibraries to another path=2E You can later provide this path to pg_upgrade=
=2E

After successful upgrade, delete the saved old files=2E=20

Regards
Holger

--=20
Holger Jakobs, Bergisch Gladbach=20
Tel=2E +49 178 9759012

Am 8=2E Oktober 2024 13:20:58 MESZ schrieb Sameer Malve <malvesameer@gmail=
=2Ecom>:
>+purav=2Echovatia@mobileum=2Ecom <purav=2Echovatia@mobileum=2Ecom>
>
>Hi Laurenz ,
>
>We have installed the PostgreSQL from RHEL repo using `dnf install <packa=
ge
>name>` so we have not passed any customised path for installation=2E
>
>And there the problem arises as older version binaries get overwritten wh=
en
>we upgrade/ install the new version of Postgres=2E
>
>Regards,
>Sameer Malve
>
>On Tue, Oct 8, 2024 at 4:18=E2=80=AFPM Laurenz Albe <laurenz=2Ealbe@cyber=
tec=2Eat>
>wrote:
>
>> On Tue, 2024-10-08 at 16:03 +0530, Sameer Malve wrote:
>> [about pg_upgrade]
>> > Does this Upgrade command stand true in case of postgres upgrade betw=
een
>> community (PGDG) to RHEL?
>>
>> Probably, unless they configured something differently that affects
>> the storage format=2E  Try and see=2E
>>
>> Recommendation: keep using PGDG packages=2E
>>
>> Yours,
>> Laurenz Albe
>>

------0CU5PIMLERLP9VLIKBR2N6Q3S7G8HU
Content-Type: text/html;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div dir=3D"auto">Before installing the new versio=
n over the old one, save the binaries and libraries to another path=2E You =
can later provide this path to pg_upgrade=2E<br><br>After successful upgrad=
e, delete the saved old files=2E <br><br>Regards<br>Holger<br></div><div di=
r=3D"auto"><div class=3D'k9mail-signature'>-- <br>Holger Jakobs, Bergisch G=
ladbach <br>Tel=2E +49 178 9759012</div></div><br><br><div class=3D"gmail_q=
uote"><div dir=3D"auto">Am 8=2E Oktober 2024 13:20:58 MESZ schrieb Sameer M=
alve &lt;malvesameer@gmail=2Ecom&gt;:</div><blockquote class=3D"gmail_quote=
" style=3D"margin: 0pt 0pt 0pt 0=2E8ex; border-left: 1px solid rgb(204, 204=
, 204); padding-left: 1ex;">
<div dir=3D"ltr"><a class=3D"gmail_plusreply" id=3D"plusReplyChip-0" href=
=3D"mailto:purav=2Echovatia@mobileum=2Ecom" tabindex=3D"-1">+purav=2Echovat=
ia@mobileum=2Ecom</a>&nbsp;<div><a class=3D"gmail_plusreply"><br></a></div>=
<div>Hi Laurenz ,</div><div><br></div><div>We have installed the PostgreSQL=
 from RHEL repo using `dnf install &lt;package name&gt;` so we have not pas=
sed any customised path for installation=2E</div><div><br></div><div>And th=
ere the problem arises as older version binaries&nbsp;get overwritten when =
we upgrade/ install the new version of Postgres=2E&nbsp;&nbsp;<br><a class=
=3D"gmail_plusreply"><br></a></div><div>Regards,</div><div>Sameer Malve</di=
v></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr=
">On Tue, Oct 8, 2024 at 4:18=E2=80=AFPM Laurenz Albe &lt;<a href=3D"mailto=
:laurenz=2Ealbe@cybertec=2Eat">laurenz=2Ealbe@cybertec=2Eat</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=2E=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Tue, 2024-1=
0-08 at 16:03 +0530, Sameer Malve wrote:<br>
[about pg_upgrade]<br>
&gt; Does this Upgrade command stand true in case of postgres upgrade betw=
een community (PGDG) to RHEL?<br>
<br>
Probably, unless they configured something differently that affects<br>
the storage format=2E&nbsp; Try and see=2E<br>
<br>
Recommendation: keep using PGDG packages=2E<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>
</blockquote></div></body></html>
------0CU5PIMLERLP9VLIKBR2N6Q3S7G8HU--