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
Database: postgres
Database: template1
postgres=# \dx plpython2u
List of installed extensions
Name | Version | Schema | Description
------+---------+--------+-------------
(0 rows)
List of installed extensions
Name | Version | Schema | Description
------+---------+--------+-------------
(0 rows)
template1=# \dx plpython2u
List of installed extensions
Name | Version | Schema | Description
------+---------+--------+-------------
(0 rows)
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@xxxxxxxxxx> 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