pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade from 9.5 to 12 fails due to plpythonu2
2+ messages / 2 participants
[nested] [flat]
* pg_upgrade from 9.5 to 12 fails due to plpythonu2
@ 2020-01-21 09:30 Shrikant Bhende <shrikantpostgresql@gmail.com>
2020-01-21 15:29 ` Re: pg_upgrade from 9.5 to 12 fails due to plpythonu2 Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: Shrikant Bhende @ 2020-01-21 09:30 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org; pgsql-admin
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?
Thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_upgrade from 9.5 to 12 fails due to plpythonu2
2020-01-21 09:30 pg_upgrade from 9.5 to 12 fails due to plpythonu2 Shrikant Bhende <shrikantpostgresql@gmail.com>
@ 2020-01-21 15:29 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2020-01-21 15:29 UTC (permalink / raw)
To: Shrikant Bhende <shrikantpostgresql@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org; pgsql-admin
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 +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-01-21 15:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-21 09:30 pg_upgrade from 9.5 to 12 fails due to plpythonu2 Shrikant Bhende <shrikantpostgresql@gmail.com>
2020-01-21 15:29 ` Bruce Momjian <bruce@momjian.us>
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