Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfjgn-00Cvxe-S9 for pgsql-general@arkaria.postgresql.org; Mon, 11 Sep 2023 16:23:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qfjgm-001qe9-LX for pgsql-general@arkaria.postgresql.org; Mon, 11 Sep 2023 16:23:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfjgm-001qdv-A9 for pgsql-general@lists.postgresql.org; Mon, 11 Sep 2023 16:23:04 +0000 Received: from mout.kundenserver.de ([217.72.192.74]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfjgi-004Tyo-ER for pgsql-general@lists.postgresql.org; Mon, 11 Sep 2023 16:23:03 +0000 Received: from [192.168.1.9] ([78.141.12.8]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.179]) with ESMTPSA (Nemesis) id 1MRSdf-1qIPW21YO5-00NTjZ for ; Mon, 11 Sep 2023 18:22:59 +0200 Content-Type: multipart/alternative; boundary="------------HEktKyueUhcEhBQiHHZA7dOn" Message-ID: <4e70f17d-1323-4a74-9b05-c7a76868f815@gemmill.name> Date: Mon, 11 Sep 2023 17:22:57 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Upgrade problem Content-Language: en-GB To: pgsql-general@lists.postgresql.org References: <2621665.1694448638@sss.pgh.pa.us> From: Graeme In-Reply-To: <2621665.1694448638@sss.pgh.pa.us> X-Provags-ID: V03:K1:NFRuEGoYLlgtty8WgszVSQ2DHzl3/i46mJFYtAsLw0y/FUBqwFQ 2IQVCev4uOzNriSaZdVA0b3WoLAIG8RVw4821MqNgDLsm6JZe9aSkhhj7MCWjBETpqwfMz3 zDTQ6ojCdpPIa2mAC8a2Hgv9glZg2oSGXL9iDxZ7ZHvDFiNj7VzJVRoO+SSoihBGMwDvMVB i/oHYuiZXQBCipmLxhheg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:QCrork/k+TY=;/weeqa7CPzdpY1tffMdwmLOA0gC Cb6FsiiFFA1vRtRXwLAWE15DjcuCKBEHnVPcGsj8//eR43o2YyADD+bmi7h+M9vk04P13r++J AVTsywHm8hRQ+SACWG5vCHHZenPO1nIZ6beYyRScxnZvOQdhkMzYB5nAxAfCIDDkheC95w2pV 4ATCWMKGcIokHH4zKAae5xnywrqV0OHos3TbwUBk0UdsV1Ddki52pW2ZklYFASnYMD19OtU7M uglJHug3AOP7UHKZkOWjz/aAWkmUpis4ukbckikONYQvpvozcYG/JUFxlwy0umH5N3mn2efNl gcloBR/I4+NMzL3553DA7tLoD2R+c2/NvJxAGX1NHQ8v9wbhYzVAlR8fFpTFfK1XL0+VkdbFn C/86r4B0QCXuMPuqq5M0hw2or5hmrwjSDdBrgVMZWsmrFD7kl41cTU31t53vkeomJLEuc9qqL EqCBS1gLPOvDZ0T2I8Y0DH4UrRNCVikaYpCKyV0nSiyl082YWB0nWyNfqk6opVzSlh2hU8ow7 RdQNCWlYvHfuEQxfqoQBMWGdWCmDCbjnBD250HHdJ+MMM92DFoj9TrGh2vC0W4oibdkTP/S3s aq+5KZ8t83czYjn8JUShn+2JEmkAGZ3QNH+8IQ+e1DLd2h6xpMch5sV//ThS/DwvQ5mCirizh btX6c7BQwHXSlw9NzgFGFb7m/pgfurXaXvxJyKXxxVSmyVK50AQS/O+nZST5HC8a5LgiHme3b QUFT61JfmggEY2qpLFIeivxNdV25Y8s9cNdUaKTS+e+kYSbaMLZo/nh/9im0nuGgiTJBA+Iom 4BZwep9mTz4xMQp73e+xpjNC7bAN+woFmJBS8Zo28WxMsEADlDGq9LzMdmPV9zTwFxCx3ZhRs Gm/WMnGdnsQwidQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------HEktKyueUhcEhBQiHHZA7dOn Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 11/09/2023 17:10, Tom Lane wrote: > Graeme writes: >> Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg >> 15. I'm at the point of running pg_upgrade but have received anerror >> message: >> /mga8/usr/bin/postgres: error while loading shared libraries: >> libssl.so.1.1: cannot open shared object file: No such file or directory >> no data was returned by command ""/mga8/usr/bin/postgres" -V" > You might get useful info from "ldd /mga8/usr/bin/postgres" > about where that executable is looking for libssl. > > regards, tom lane Tom, thanks: it's finding other so. files in the correct place libpam.so.0 => /lib64/libpam.so.0 (0x00007f8d49e1e000) libssl.so.1.1 => not found libcrypto.so.1.1 => not found librt.so.1 => /lib64/librt.so.1 (0x00007f8d49e16000) so there must be another problem. Graeme --------------HEktKyueUhcEhBQiHHZA7dOn Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
On 11/09/2023 17:10, Tom Lane wrote:
Graeme <graeme@gemmill.name> writes:
Preparing to upgrade my small cluster from Mageia 8/Pg 9 to Mageia 9/Pg 
15. I'm at the point of running pg_upgrade but have received anerror 
message:

      
/mga8/usr/bin/postgres: error while loading shared libraries: 
libssl.so.1.1: cannot open shared object file: No such file or directory
no data was returned by command ""/mga8/usr/bin/postgres" -V"
You might get useful info from "ldd /mga8/usr/bin/postgres"
about where that executable is looking for libssl.

			regards, tom lane

Tom, thanks: it's finding other so. files in the correct place

libpam.so.0 => /lib64/libpam.so.0 (0x00007f8d49e1e000)
libssl.so.1.1 => not found
libcrypto.so.1.1 => not found
librt.so.1 => /lib64/librt.so.1 (0x00007f8d49e16000)


so there must be another problem.

Graeme

--------------HEktKyueUhcEhBQiHHZA7dOn--