pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcould not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
5+ messages / 3 participants
[nested] [flat]
* could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
@ 2021-03-05 07:03 RAJAMOHAN <garajamohan@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: RAJAMOHAN @ 2021-03-05 07:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
@ 2021-03-05 08:59 Holger Jakobs <holger@jakobs.com>
parent: RAJAMOHAN <garajamohan@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Holger Jakobs @ 2021-03-05 08:59 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
@ 2021-03-07 07:01 RAJAMOHAN <garajamohan@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 5+ messages in thread
From: RAJAMOHAN @ 2021-03-07 07:01 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
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@jakobs.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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
@ 2021-03-07 16:20 Tom Lane <tgl@sss.pgh.pa.us>
parent: RAJAMOHAN <garajamohan@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2021-03-07 16:20 UTC (permalink / raw)
To: RAJAMOHAN <garajamohan@gmail.com>; +Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org
RAJAMOHAN <garajamohan@gmail.com> writes:
> But the issue is still occurring for me, even though I dropped the
> *plpython2u* extension and functions which were using the it.
Look through pg_proc for entries mentioning plpython2 in probin, ie
select proname from pg_proc where probin like '%plpython2%';
Another possibility is that you added plpython2 to shared_preload_libraries
or one of its sibling settings.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
@ 2021-03-08 14:29 RAJAMOHAN <garajamohan@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: RAJAMOHAN @ 2021-03-08 14:29 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org
Thanks Tom,
Query helped. After removing the functions below, the upgrade went well.
plpython2_call_handler;
plpython2_inline_handler;
plpython2_validator;
Thanks & Regards,
Raj
On Sun, Mar 7, 2021 at 9:50 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> RAJAMOHAN <garajamohan@gmail.com> writes:
> > But the issue is still occurring for me, even though I dropped the
> > *plpython2u* extension and functions which were using the it.
>
> Look through pg_proc for entries mentioning plpython2 in probin, ie
>
> select proname from pg_proc where probin like '%plpython2%';
>
> Another possibility is that you added plpython2 to shared_preload_libraries
> or one of its sibling settings.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-03-08 14:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-05 07:03 could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12 RAJAMOHAN <garajamohan@gmail.com>
2021-03-05 08:59 ` Holger Jakobs <holger@jakobs.com>
2021-03-07 07:01 ` RAJAMOHAN <garajamohan@gmail.com>
2021-03-07 16:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-03-08 14:29 ` RAJAMOHAN <garajamohan@gmail.com>
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