From: Bruce Momjian <bruce@momjian.us>
To: Shrikant Bhende <shrikantpostgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade from 9.5 to 12 fails due to plpythonu2
Date: Tue, 21 Jan 2020 10:29:53 -0500
Message-ID: <20200121152953.GA7083@momjian.us> (raw)
In-Reply-To: <CAMTQpJCYUCSvw43cDbBUc2Ss950axtG2B5rYBcveZ0PvkXMqVA@mail.gmail.com>
References: <CAMTQpJCYUCSvw43cDbBUc2Ss950axtG2B5rYBcveZ0PvkXMqVA@mail.gmail.com>
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@momjian.us> 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 +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, shrikantpostgresql@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_upgrade from 9.5 to 12 fails due to plpythonu2
In-Reply-To: <20200121152953.GA7083@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox