Re: Upgrade problem

On 11/09/2023 17:13, Adrian Klaver wrote:
> On 9/11/23 09: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:
>
> You are going to have to be more specific on the Postgres version.
> Prior to Postgres 10 major version changes where two digits. So for
> Postgres 9.X.x that meant 9.0.x --> 9.6.x
Don't have access to that version without re-booting; probably 9.5
>
>>
>> /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"
>
> Where are you running the pg_upgrade and what version of it are you
> using?
>
pg_upgrade (PostgreSQL) 15.3

I specified -B /usr/bin

>>
>> However:
>>
>> [root(at)bach lib64]# cd /mga8/usr/lib64
>> [root(at)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
>