public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Bharani SV-forum <[email protected]>
To: Greg Sabino Mullane <[email protected]>
To: Ron Johnson <[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 14.X/15.X and issue with python binaries
Date: Tue, 28 Jan 2025 11:36:00 -0800
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]>
<[email protected]>
<[email protected]>
<[email protected]>
On 1/28/25 08:23, Bharani SV-forum wrote:
> Team
> Need your help.
> We are trying to use existing VM with underlying OS = Amazon Linux 2
> (AL2) along with Pgsql ver 13.X community edn.
> Trying to upgrade from 13.X to 15.X and had hit the bottleneck for the
> mandate to have python ver 3.X binaries.
> We have limitation with the existing VM with AWS and currently AL2 uses
> the |yum| package manager that has a hard dependency on Python 2.7 and
> the pgsql ver 15. needed Ver 3.x python binaries and the package
> community edition (pgsql ver 15.x) "postgresql15-contrib.." is not
> getting installed.
>
> We have limitation , where the application being used is having python
> ver 2.x binaries and we cannot install python 3.x binaries , as we have
> the underlying OS with AL2 which is having "a hard dependency on Python 2.7"
>
> In lieu of using pgsql ver 15.X. We are OK to upgrade to the next
> version which is 14.X from existing ver 13.X.
>
> Can anyone re-confirm if the Community edition (pgsql ver14.x) -
> "postgresql14-contrib .." needed python ver 2.X binaries or Ver 3.X
> binaries.
From here:
https://yum.postgresql.org/14/redhat/rhel-7-x86_64/repoview/postgresql14-contrib.html
postgresql14-contrib-14.15-1PGDG.rhel7.x86_64
hstore_plpython3.so
jsonb_plpython3.so
ltree_plpython3.so
So I'm going to say yes Python 3 is needed.
FYI I don't see those files in postgresql13-contrib.
If you want to move forward you need to either install Python 3 in your
current distro or use a different distro.
>
> I cross checked and found one of the url " Install Postgres v14 +
> -contrib on AWS Linux 2 | the gabriellephant
> <https://gorthx.wordpress.com/2022/02/08/install-postgres-v14-contrib-on-aws-linux-2/>"; is quoting pgsql ver 14.x needed python ver 3.x binary
>
> On Friday, January 24, 2025 at 02:14:56 PM EST, Adrian Klaver
> <[email protected]> wrote:
>
>
>
>
--
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 14.X/15.X and issue with python binaries
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