pg_upgrade from 9.5 to 12 fails due to plpythonu2

From: Shrikant Bhende <shrikantpostgresql(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade from 9.5 to 12 fails due to plpythonu2
Date: 2020-01-21 09:30:24
Message-ID: CAMTQpJCYUCSvw43cDbBUc2Ss950axtG2B5rYBcveZ0PvkXMqVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I am trying to upgrade a PostgreSQL cluster running on version 9.5 to 12,
most of the code is written in the form of procedures using pl/python
(version 2 and version 3), while running pg_upgrade I am getting below
error,

"Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt"

Old installation uses both the versions of plpython (2 and 3 and I am
getting error for 2 which is not supported in 12.

*Contents of loadable_libraries.txt *

could not load library "$libdir/plpython2": ERROR: could not access file
"$libdir/plpython2": No such file or directory
Database: cctest
Database: master
Database: postgres
Database: vmware
could not load library "$libdir/plugin_debugger": ERROR: could not access
file "$libdir/plugin_debugger": No such file or directory
Database: vmware

I have tried to install plpython2 with PostgreSQL 12 but I guess that's not
supported, also I am not able to find out anything related to debugging in
PostgreSQL.
What will be the efficient way to upgrade from 9.5 to 12 with plpython2
dependency in the code?

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Douglas Reed 2020-01-21 10:41:04 Replication Question
Previous Message Shrikant Bhende 2020-01-21 05:39:30 Re: pg_upgrade from 9.5.10 to 12 fails with encoding issue