Обсуждение: Upgrade Rhel7.9 to Rhel9.3

Поиск
Список
Период
Сортировка

Upgrade Rhel7.9 to Rhel9.3

От
Дата:

We are upgrading our servers from rhel7.9 to rhel9.3. Currently we run postgres version  12 on Rhel 7.9.

After the upgrade will postgres 12 run on rhel9.3 ? Will I have issues with shared libraries etc…

 

Thanks

Gary

Re: Upgrade Rhel7.9 to Rhel9.3

От
Joe Conway
Дата:
On 3/6/24 11:27, garyorban@gmail.com wrote:
> We are upgrading our servers from rhel7.9 to rhel9.3. Currently we run 
> postgres version  12 on Rhel 7.9.
> 
> After the upgrade will postgres 12 run on rhel9.3 ?

Presumably you will install the RHEL 9 packages which will be built with 
all of the needed dependencies. If so, you should be fine there.

> Will I have issues with shared libraries etc…

But beware of collation changes. You will almost certainly need to 
rebuild some indexes afterwards.

Lest you think you will not be affected, see:
   https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf

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




RE: Upgrade Rhel7.9 to Rhel9.3

От
Дата:
When we tried on a test server we were seeing issues with libcrypto.so.10 and libssl.so.10

I know sometimes symlinks are needed but we can't seem to get these to work which led to my question of if postgres12
wassupported on rhel9.3  

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

On 3/6/24 11:27, garyorban@gmail.com wrote:
> We are upgrading our servers from rhel7.9 to rhel9.3. Currently we run
> postgres version  12 on Rhel 7.9.
>
> After the upgrade will postgres 12 run on rhel9.3 ?

Presumably you will install the RHEL 9 packages which will be built with all of the needed dependencies. If so, you
shouldbe fine there. 

> Will I have issues with shared libraries etc…

But beware of collation changes. You will almost certainly need to rebuild some indexes afterwards.

Lest you think you will not be affected, see:
   https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf

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





Re: Upgrade Rhel7.9 to Rhel9.3

От
Joe Conway
Дата:
On 3/6/24 11:38, garyorban@gmail.com wrote:
> When we tried on a test server we were seeing issues with
> libcrypto.so.10 and libssl.so.10
> 
> I know sometimes symlinks are needed but we can't seem to get these
> to work which led to my question of if postgres12 was supported on
> rhel9.3

How/where are you getting the postgres binaries? They need to be 
compiled/linked with the libraries on the rhel9 system, and it sounds 
like you may have built the postgres binaries yourself on rhel7?

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




RE: Upgrade Rhel7.9 to Rhel9.3

От
Дата:
version 12 was installed on this server with rhel7 . Now  the server has been upgraded to rhel9.

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

Thanks
Gary

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

On 3/6/24 11:38, garyorban@gmail.com wrote:
> When we tried on a test server we were seeing issues with
> libcrypto.so.10 and libssl.so.10
>
> I know sometimes symlinks are needed but we can't seem to get these to
> work which led to my question of if postgres12 was supported on
> rhel9.3

How/where are you getting the postgres binaries? They need to be compiled/linked with the libraries on the rhel9
system,and it sounds like you may have built the postgres binaries yourself on rhel7? 

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





Re: Upgrade Rhel7.9 to Rhel9.3

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

explains the issue...

> So do I need to relink the postgres binaries now . If so how do I do
> 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




RE: Upgrade Rhel7.9 to Rhel9.3

От
Дата:
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>
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
> has been upgraded to rhel9.

explains the issue...

> So do I need to relink the postgres binaries now . If so how do I do
> 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





Re: Upgrade Rhel7.9 to Rhel9.3

От
Laurenz Albe
Дата:
On Wed, 2024-03-06 at 11:27 -0500, garyorban@gmail.com wrote:
> We are upgrading our servers from rhel7.9 to rhel9.3. Currently we run postgres version  12 on Rhel 7.9.
>  After the upgrade will postgres 12 run on rhel9.3 ? Will I have issues with shared libraries etc…

No, but you will have issues with currupted indexes, because the C library
collations change.  Rebuild all indexes on strings.

Yours,
Laurenz Albe



Re: Upgrade Rhel7.9 to Rhel9.3

От
Scott Ribe
Дата:
> On Mar 6, 2024, at 1:33 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> Rebuild all indexes on strings.

Emphasis on *ALL*, as it wasn't just Unicode or 8-bit "ASCII" changes, there were changes affecting plain 7-bit ASCII.


Re: Upgrade Rhel7.9 to Rhel9.3

От
Joe Conway
Дата:
On 3/6/24 14:49, garyorban@gmail.com wrote:
> 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?

Yeah, it can be done like that but it sounds a bit sketchy and would 
make me nervous.

I would recommend installing the rhel9  binaries from RPMs instead.
See https://yum.postgresql.org/ for the Postgres community curated repo, 
for example.

As long as the rhel9 new binaries are the same architecture (e.g. 
x86_64) and major version (e.g. 12.18), they should "just work" with 
your existing data directory.

Although that said, as I mentioned in my first response, indexes built 
on collatable columns most likely need to be rebuilt due to the newer 
version of glibc on the rhel9 system. The rebuilds should be done 
*before* allowing any "writes" (inserts or updates) to the new instance. 
Other potential collation issues as illustrated in the presentation I 
linked should also be considered, e.g. partition keys.

Overall, it sounds to me like you should get a consulting/support 
company to help you with this. See: 
https://www.postgresql.org/support/professional_support/

Hope this helps,

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