Re: pg_upgrade from 12 to 13 failes with plpython2

Hi, not the case I believe :

postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
argosrm | pgsql | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 |
postgres | pgsql | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 |
template0 | pgsql | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 | =c/pgsql +
| | | | | pgsql=CTc/pgsql
template1 | pgsql | UTF8 | pl_PL.UTF-8 | pl_PL.UTF-8 | =c/pgsql +
| | | | | pgsql=CTc/pgsql
(4 rows)

all DBs checked and no plpython(2u) is found except for plpython3u

...

cat loadable_libraries.txt
could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such file or directory
In database: argosrm
In database: template1

Thx
M.

Od: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>
Do: "Marcin Giedz" <marcin(dot)giedz(at)arise(dot)pl>, "Magnus Hagander" <magnus(at)hagander(dot)net>
DW: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Devrim Gündüz" <devrim(at)gunduz(dot)org>, "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
Wysłane: środa, 18 listopad 2020 12:58:45
Temat: Re: pg_upgrade from 12 to 13 failes with plpython2

On Wed, 2020-11-18 at 11:05 +0100, Marcin Giedz wrote:
> right, I had one function relaying on plpython2u so I changed it... but the again pg_upgrade claims error with python:
>
> cat loadable_libraries.txt
> could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such file or directory
> In database: argosrm
> In database: template1

The problematic function is perhaps in another database.
Look everywhere.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com