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" <[email protected]> Do: "Marcin Giedz" <[email protected]>, "Magnus Hagander" <[email protected]> DW: "Adrian Klaver" <[email protected]>, "Tom Lane" <[email protected]>, "Devrim Gündüz" <[email protected]>, "pgsql-general" <[email protected]> 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
