Feedback-ID: i76984098:Fastmail
Message-ID: <c3fc88ef-d155-4455-bc01-2c569b401998@aklaver.com>
Date: Fri, 24 Jan 2025 08:22:18 -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 15.X
To: Bharani SV-forum <esteembsv-forum@yahoo.com>,
 Greg Sabino Mullane <htamfids@gmail.com>,
 "ronljohnsonjr@gmail.co" <ronljohnsonjr@gmail.co>
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>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <1763130721.4001842.1737733841628@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/c3fc88ef-d155-4455-bc01-2c569b401998%40aklaver.com>
Precedence: bulk

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