Re: Upgrade problem - Mailing list pgsql-general

From Graeme
Subject Re: Upgrade problem
Date
Msg-id 8d11f7e9-4605-444b-b716-063784cb6c1a@gemmill.name
Whole thread Raw
In response to Upgrade problem  (Graeme <graeme@gemmill.name>)
Responses Re: Upgrade problem
List pgsql-general
On 11/09/2023 17:04, Graeme wrote:

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"

However:

[root@bach lib64]# cd /mga8/usr/lib64
[root@bach lib64]# ls -l|grep libssl
-rwxr-xr-x  1 root root      426192 Jul  5 23:07 libssl3.so*
lrwxrwxrwx  1 root root          13 Jun  1 09:35 libssl.so -> libssl.so.1.1*
-r-xr-xr-x  1 root root      442424 Feb 27  2021 libssl.so.1.0.0*
-rwxr-xr-x  1 root root      666496 Jun  1 09:36 libssl.so.1.1*

Can someone suggest my next move please?

Ta

Graeme Gemmill

Tom, Adrian, Ray: thanks for your comments. I see the problem now, trying to gat a Mga8 module to link against Mga9 libraries. I suspecy a carefully placed sym-link or two will sort the problem.

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Upgrade problem
Next
From: duc hiep ha
Date:
Subject: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?