Feedback-ID: i76984098:Fastmail
Message-ID: <74599d1d-c8a2-4e59-a50d-019dcc973de8@aklaver.com>
Date: Tue, 28 Jan 2025 11:36:00 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
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
To: Bharani SV-forum <esteembsv-forum@yahoo.com>,
 Greg Sabino Mullane <htamfids@gmail.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
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>
 <132487461.4068668.1737741687606@mail.yahoo.com>
 <0dc06cb7-33cc-43ba-a95f-535fdf0a0439@aklaver.com>
 <1751608443.5432365.1738081421269@mail.yahoo.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <1751608443.5432365.1738081421269@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/74599d1d-c8a2-4e59-a50d-019dcc973de8%40aklaver.com>
Precedence: bulk

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 
> <adrian.klaver@aklaver.com> wrote:
> 
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com