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.a...@cybertec.at> Do: "Marcin Giedz" <marcin.gi...@arise.pl>, "Magnus Hagander" <mag...@hagander.net> DW: "Adrian Klaver" <adrian.kla...@aklaver.com>, "Tom Lane" <t...@sss.pgh.pa.us>, "Devrim Gündüz" <dev...@gunduz.org>, "pgsql-general" <pgsql-general@lists.postgresql.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
