Re: pg_upgrade from 12 to 13 failes with plpython2

[Marcin Giedz <marcin.giedz@xxxxxxxx>]

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.albe@xxxxxxxxxxx>
Do: "Marcin Giedz" <marcin.giedz@xxxxxxxx>, "Magnus Hagander" <magnus@xxxxxxxxxxxx>
DW: "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>, "Tom Lane" <tgl@xxxxxxxxxxxxx>, "Devrim Gündüz" <devrim@xxxxxxxxxx>, "pgsql-general" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
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