Date: Fri, 24 Jan 2025 18:01:27 +0000 (UTC)
From: Bharani SV-forum <esteembsv-forum@yahoo.com>
To: Greg Sabino Mullane <htamfids@gmail.com>, 
	"ronljohnsonjr@gmail.co" <ronljohnsonjr@gmail.co>, 
	Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Message-ID: <132487461.4068668.1737741687606@mail.yahoo.com>
In-Reply-To: <c3fc88ef-d155-4455-bc01-2c569b401998@aklaver.com>
References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <A01D7215-2691-4FA6-8B79-E197B7DB9351@gmail.com> <98965993.3138805.1731699978332@mail.yahoo.com> <564950518.5117550.1733177884387@mail.yahoo.com> <CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com> <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <CAKAnmmKZdhnhdNRd3OgDyEco9OPkT=qA_TeWMFMRvUM9pXauKg@mail.gmail.com> <1482982714.8486017.1735661703839@mail.yahoo.com> <1763130721.4001842.1737733841628@mail.yahoo.com> <c3fc88ef-d155-4455-bc01-2c569b401998@aklaver.com>
Subject: Re: Help in vetting error using "pg_upgrade" - steps for Postgres
 DB upgrade from Ver 13.X to ver 15.X
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_4068667_273557996.1737741687604"
Content-Length: 7459
Archived-At: <https://www.postgresql.org/message-id/132487461.4068668.1737741687606%40mail.yahoo.com>
Precedence: bulk

------=_Part_4068667_273557996.1737741687604
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 AdrianThanks
This is the exact error which the system admin is facing

=C2=A0postgresql15-contrib installation on Amazon Linux 2 fails on Python s=
hared lib dependency

"https://www.postgresql.org/message-id/CABUevEz_OHR%2BaGU%2B7yuhpfJD%2BeWgC=
8aHgVRjP5U30kJqu%2B7jmg%40mail.gmail.com"
    On Friday, January 24, 2025 at 11:22:23 AM EST, Adrian Klaver <adrian.k=
laver@aklaver.com> wrote: =20
=20
 On 1/24/25 07:50, Bharani SV-forum wrote:
> Team
> Need your additional input.
> VM is based on EC2 OS Version =3D Amazon Linux 2
> Existing DB version =3D 13.X - Pg Community under EC2 - VM (Same VM)
> Target DB version =3D 15.x =C2=A0- Pg Community under EC2 - VM (Same VM)
>=20
> i will narrate the latest error
>=20
>=20
>=20
> executing: SELECT pg_catalog.set_config('search_path', '', false);
> Checking for presence of required libraries=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0fatal
>=20

>=20
> Any guidance how to come the error.
>=20
> my unix system admin is quoting that=C2=A0 he is facing built issue with=
=20
> postgres15 version w.r.to " postgresql15-contrib.x86_64 "
> under AWS based OS " Amazon Linux 2=C2=A0 ".
> His version is "It needs libpython3.6m.so.1.0()(64bit) to install=20
> package: postgresql15-contrib-15.10-1PGDG.rhel7.x86_64. in our=20
> environment. I can't install python3.6 libraries because we already have=
=20
> a different python version installed and clashing"

 From what I know Amazon Linux 2 is a RH clone, confirmed by=20
postgresql15-contrib-15.10-1PGDG.rhel7.x86_64 above.

 From link below it seems it is possible to run multiple versions of=20
Python together RH7 so it should work on AL2 also(?):

https://developers.redhat.com/blog/install-python3-rhel#installing_python_3=
_on_rhel_7

>=20
> Any quidance to overcome the error, as the existing python version being=
=20
> used by us is clashing with the pre.req version python ver 3.6
>=20
> My unix admin, too quoted me to have it installed under OS RHEL7 w.r.to=
=20
> postgresql - EC2 version
> Best Viable option. I have tried with previous suggestion steps and=20
> found "pg_upgrade" as the most viable and faster
>=20
> Regards


--=20
Adrian Klaver
adrian.klaver@aklaver.com

 =20
------=_Part_4068667_273557996.1737741687604
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydp8b16ef01yahoo-style-wrap" style=
=3D"font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px=
;"><div></div>
        <div dir=3D"ltr" data-setdir=3D"false">Adrian</div><div dir=3D"ltr"=
 data-setdir=3D"false">Thanks</div><div dir=3D"ltr" data-setdir=3D"false"><=
br></div><div dir=3D"ltr" data-setdir=3D"false">This is the exact error whi=
ch the system admin is facing</div><div dir=3D"ltr" data-setdir=3D"false"><=
br></div><div dir=3D"ltr" data-setdir=3D"false"><span><h1 class=3D"ydpc0a75=
0edsubject" style=3D"margin: 0.67em 0px; font-family: Open Sans, sans-serif=
; line-height: 1.2; font-size: 1.2em;">&nbsp;postgresql15-contrib installat=
ion on Amazon Linux 2 fails on Python shared lib dependency</h1></span><br>=
</div><div dir=3D"ltr" data-setdir=3D"false">"<span class=3D"ydp78e56d93pas=
ted-link"><span style=3D"font-size: 13px;">https://www.postgresql.org/messa=
ge-id/CABUevEz_OHR%2BaGU%2B7yuhpfJD%2BeWgC8aHgVRjP5U30kJqu%2B7jmg%40mail.gm=
ail.com"</span></span></div><div><br></div>
       =20
        </div><div id=3D"ydp8bec95f9yahoo_quoted_8408699552" class=3D"ydp8b=
ec95f9yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Friday, January 24, 2025 at 11:22:23 AM EST, Adr=
ian Klaver &lt;adrian.klaver@aklaver.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">On 1/24/25 07:50, Bharani SV-forum wr=
ote:<br clear=3D"none">&gt; Team<br clear=3D"none">&gt; Need your additiona=
l input.<br clear=3D"none">&gt; VM is based on EC2 OS Version =3D Amazon Li=
nux 2<br clear=3D"none">&gt; Existing DB version =3D 13.X - Pg Community un=
der EC2 - VM (Same VM)<br clear=3D"none">&gt; Target DB version =3D 15.x &n=
bsp;- Pg Community under EC2 - VM (Same VM)<br clear=3D"none">&gt; <br clea=
r=3D"none">&gt; i will narrate the latest error<br clear=3D"none">&gt; <br =
clear=3D"none">&gt; <br clear=3D"none">&gt; <br clear=3D"none">&gt; executi=
ng: SELECT pg_catalog.set_config('search_path', '', false);<br clear=3D"non=
e">&gt; Checking for presence of required libraries&nbsp; &nbsp; &nbsp; &nb=
sp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;fatal<br clear=3D"none">&gt; <br clea=
r=3D"none"><br clear=3D"none">&gt; <br clear=3D"none">&gt; Any guidance how=
 to come the error.<br clear=3D"none">&gt; <br clear=3D"none">&gt; my unix =
system admin is quoting that&nbsp; he is facing built issue with <br clear=
=3D"none">&gt; postgres15 version w.r.to " postgresql15-contrib.x86_64 "<br=
 clear=3D"none">&gt; under AWS based OS " Amazon Linux 2&nbsp; ".<br clear=
=3D"none">&gt; His version is "It needs libpython3.6m.so.1.0()(64bit) to in=
stall <br clear=3D"none">&gt; package: postgresql15-contrib-15.10-1PGDG.rhe=
l7.x86_64. in our <br clear=3D"none">&gt; environment. I can't install pyth=
on3.6 libraries because we already have <br clear=3D"none">&gt; a different=
 python version installed and clashing"<br clear=3D"none"><br clear=3D"none=
"> From what I know Amazon Linux 2 is a RH clone, confirmed by <br clear=3D=
"none">postgresql15-contrib-15.10-1PGDG.rhel7.x86_64 above.<br clear=3D"non=
e"><br clear=3D"none"> From link below it seems it is possible to run multi=
ple versions of <br clear=3D"none">Python together RH7 so it should work on=
 AL2 also(?):<br clear=3D"none"><br clear=3D"none"><a shape=3D"rect" href=
=3D"https://developers.redhat.com/blog/install-python3-rhel#installing_pyth=
on_3_on_rhel_7" rel=3D"nofollow" target=3D"_blank">https://developers.redha=
t.com/blog/install-python3-rhel#installing_python_3_on_rhel_7</a><div class=
=3D"ydp8bec95f9yqt4638481053" id=3D"ydp8bec95f9yqtfd02956"><br clear=3D"non=
e"><br clear=3D"none">&gt; <br clear=3D"none">&gt; Any quidance to overcome=
 the error, as the existing python version being <br clear=3D"none">&gt; us=
ed by us is clashing with the pre.req version python ver 3.6<br clear=3D"no=
ne">&gt; <br clear=3D"none">&gt; My unix admin, too quoted me to have it in=
stalled under OS RHEL7 w.r.to <br clear=3D"none">&gt; postgresql - EC2 vers=
ion<br clear=3D"none">&gt; Best Viable option. I have tried with previous s=
uggestion steps and <br clear=3D"none">&gt; found "pg_upgrade" as the most =
viable and faster<br clear=3D"none">&gt; <br clear=3D"none">&gt; Regards</d=
iv><br clear=3D"none"><br clear=3D"none"><br clear=3D"none">-- <br clear=3D=
"none">Adrian Klaver<br clear=3D"none"><a shape=3D"rect" href=3D"mailto:adr=
ian.klaver@aklaver.com" rel=3D"nofollow" target=3D"_blank">adrian.klaver@ak=
laver.com</a><div class=3D"ydp8bec95f9yqt4638481053" id=3D"ydp8bec95f9yqtfd=
86050"><br clear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_4068667_273557996.1737741687604--