public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bharani SV-forum <[email protected]>
To: Greg Sabino Mullane <[email protected]>
To: [email protected] <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X
Date: Fri, 24 Jan 2025 18:01:27 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CANzqJaAda4nZbkG=c+72ry5GdaxrJ6Jzr6fz1quhq8tTfaX1Pg@mail.gmail.com>
<[email protected]>
<[email protected]>
<CANzqJaC1Uk4H=55vV_jbFYMuD1f9Bb_4Y9WKvkZA3bt92bEUnw@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAKAnmmKZdhnhdNRd3OgDyEco9OPkT=qA_TeWMFMRvUM9pXauKg@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
AdrianThanks
This is the exact error which the system admin is facing
postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency
"https://www.postgresql.org/message-id/CABUevEz_OHR%2BaGU%2B7yuhpfJD%2BeWgC8aHgVRjP5U30kJqu%2B7jmg%40...;
On Friday, January 24, 2025 at 11:22:23 AM EST, Adrian Klaver <[email protected]> wrote:
On 1/24/25 07:50, Bharani SV-forum wrote:
> Team
> Need your additional input.
> VM is based on EC2 OS Version = Amazon Linux 2
> Existing DB version = 13.X - Pg Community under EC2 - VM (Same VM)
> Target DB version = 15.x - Pg Community under EC2 - VM (Same VM)
>
> i will narrate the latest error
>
>
>
> executing: SELECT pg_catalog.set_config('search_path', '', false);
> Checking for presence of required libraries fatal
>
>
> Any guidance how to come the error.
>
> my unix system admin is quoting that he is facing built issue with
> postgres15 version w.r.to " postgresql15-contrib.x86_64 "
> under AWS based OS " Amazon Linux 2 ".
> His version is "It needs libpython3.6m.so.1.0()(64bit) to install
> package: postgresql15-contrib-15.10-1PGDG.rhel7.x86_64. in our
> environment. I can't install python3.6 libraries because we already have
> a different python version installed and clashing"
From what I know Amazon Linux 2 is a RH clone, confirmed by
postgresql15-contrib-15.10-1PGDG.rhel7.x86_64 above.
From link below it seems it is possible to run multiple versions of
Python together RH7 so it should work on AL2 also(?):
https://developers.redhat.com/blog/install-python3-rhel#installing_python_3_on_rhel_7
>
> Any quidance to overcome the error, as the existing python version being
> used by us is clashing with the pre.req version python ver 3.6
>
> My unix admin, too quoted me to have it installed under OS RHEL7 w.r.to
> postgresql - EC2 version
> Best Viable option. I have tried with previous suggestion steps and
> found "pg_upgrade" as the most viable and faster
>
> Regards
--
Adrian Klaver
[email protected]
view thread (61+ 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: Help in vetting error using "pg_upgrade" - steps for Postgres DB upgrade from Ver 13.X to ver 15.X
In-Reply-To: <[email protected]>
* 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