Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12

Thanks for the info Holger.

But the issue is still occurring for me, even though I dropped the
*plpython2u* extension and functions which were using the it.

Currently no extension is available in the instance. Then how come this
error is occuring?

*could not load library "$libdir/plpython2": ERROR: could not access file
"$libdir/plpython2": No such file or directory*Database: postgres
Database: template1

postgres=# \dx plpython2u
List of installed extensions
Name | Version | Schema | Description
------+---------+--------+-------------
(0 rows)

template1=# \dx plpython2u
List of installed extensions
Name | Version | Schema | Description
------+---------+--------+-------------
(0 rows)

Am i missing something here? Please suggest a solution for this problem.

Thanks & Regards,
Raj

On Fri, Mar 5, 2021 at 2:29 PM Holger Jakobs <holger(at)jakobs(dot)com> wrote:

> Hi,
>
> Since Python2 is totally deprecated, you'll have to use Python3.
>
> postgresql-plpython3-12 - PL/Python 3 procedural language for PostgreSQL 12
>
> Regards,
>
> Holger
> Am 05.03.21 um 08:03 schrieb RAJAMOHAN:
>
> Hello all,
>
> I am getting the below error while trying to upgrade from postgres 10 to
> 12 version on ubuntu machine. It seems plpython2 is not installed for the
> postgresql-12 version.
>
>
> *could not load library "$libdir/plpython2": ERROR: could not access file
> "$libdir/plpython2": No such file or directory *
>
>
> I tried to install it using the below command, but it was not successful.
> Whether I need to migrate the functions in postgres-10 instance to
> plpython3 and try upgrading OR Is there any other way to install the
> package for postgresql-12 version?
>
> apt install postgresql-plpython-12
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> E: Unable to locate package postgresql-plpython-12
>
>
> OS details:
> Operating System: Ubuntu 18.04.1 LTS
> Kernel: Linux 5.4.0-1035-aws
> Architecture: x86-64
>
>
> Thanks & Regards,
> Raj
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>