Date: Tue, 21 Jan 2020 10:29:53 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Shrikant Bhende <shrikantpostgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org, pgsql-admin@postgresql.org
Subject: Re: pg_upgrade from 9.5 to 12 fails due to plpythonu2
Message-ID: <20200121152953.GA7083@momjian.us>
References: 
 <CAMTQpJCYUCSvw43cDbBUc2Ss950axtG2B5rYBcveZ0PvkXMqVA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAMTQpJCYUCSvw43cDbBUc2Ss950axtG2B5rYBcveZ0PvkXMqVA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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 +