From: <garyorban@gmail.com>
To: "'Joe Conway'" <mail@joeconway.com>,
	<pgsql-admin@lists.postgresql.org>
References: <18e801da6fe3$22ccaff0$68660fd0$@gmail.com>
 <9cc30cb6-7496-4508-bd6f-0640213ed12b@joeconway.com>
 <18f701da6fe4$ac2fc790$048f56b0$@gmail.com>
 <44483f0d-25f2-46e2-8bfb-41fa99d7075e@joeconway.com>
 <190101da6fe6$1edc82a0$5c9587e0$@gmail.com>
 <8386b391-12b7-4852-8b5a-b8489cec7643@joeconway.com>
In-Reply-To: <8386b391-12b7-4852-8b5a-b8489cec7643@joeconway.com>
Subject: RE: Upgrade Rhel7.9 to Rhel9.3
Date: Wed, 6 Mar 2024 14:49:15 -0500
Message-ID: <194001da6fff$5ecd56f0$1c6804d0$@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: 
 AQIMX9EqKAWZXTuDkAOyuQBnmEJW7QJYMayDA2GE87sCOaWJgwJHWDhrASoj2JCwbBOoIA==
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/194001da6fff%245ecd56f0%241c6804d0%24%40gmail.com>
Precedence: bulk

Joe,

Appreciate the help. The person who performed the original upgrades in =
no longer with us.
I believe they used an RPM for that install .

I was able to get postgres 12 to start on rhel 9.3 with the following =
tweaks.

Copied over libcrypto, libssl , libreadline and libtinfo  from another  =
rhel 7 server.
Also needed symlinks for libicuil8n and libicuuc .

I was able to access the DB and perform simple queries . Do you think =
this approach will work, as I'm a bit leery .
If not what do you think would be a better option?

Gary


-----Original Message-----
From: Joe Conway <mail@joeconway.com>=20
Sent: Wednesday, March 6, 2024 12:30 PM
To: garyorban@gmail.com; pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade Rhel7.9 to Rhel9.3

On 3/6/24 11:48, garyorban@gmail.com wrote:
> version 12 was installed on this server with rhel7 . Now  the server=20
> has been upgraded to rhel9.

explains the issue...

> So do I need to relink the postgres binaries now . If so how do I do=20
> that ?

Depends on how you got the postgres binaries in the first place. Were =
they installed using RPMs, and if so, what repository? Did you build =
them yourselves? Did you get them some other way (maybe EDBs installer =
for example)?

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com