Обсуждение: 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
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
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
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
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
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
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
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
> 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.
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