On Tue, Jan 21, 2020 at 03:00:24PM +0530, Shrikant Bhende wrote: > 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? Well, I am guessing you will need to remove the use of plpython 2 from 9.5 and then do the upgrade. However, the community still supports Python 2 in PG 12: https://www.postgresql.org/docs/12/plpython-python23.html so it must be your package manager that doesn't support it or something. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
