but my question still remains the same - what causes pg_upgrade failure - are functions the reason? what I did was to delete these 2 rows from pg_pltemplate as I thought this may help:
postgres=# delete from pg_pltemplate where tmplname = 'plpython2u'; DELETE 1 postgres=# delete from pg_pltemplate where tmplname = 'plpythonu'; DELETE 1 but pg_upgrade still complains about plpython2: cat loadable_libraries.txt could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such file or directory In database: alaxx In database: template1 marcin@carbon2:~$ psql -U pgsql -h 192.168.89.64 alaxx psql (12.4 (Ubuntu 12.4-1)) Type "help" for help. argosrm=# select * from pg_pltemplate ; tmplname | tmpltrusted | tmpldbacreate | tmplhandler | tmplinline | tmplvalidator | tmpllibrary | tmplacl ------------+-------------+---------------+------------------------+--------------------------+---------------------+-------------------+--------- plpgsql | t | t | plpgsql_call_handler | plpgsql_inline_handler | plpgsql_validator | $libdir/plpgsql | pltcl | t | t | pltcl_call_handler | | | $libdir/pltcl | pltclu | f | f | pltclu_call_handler | | | $libdir/pltcl | plperl | t | t | plperl_call_handler | plperl_inline_handler | plperl_validator | $libdir/plperl | plperlu | f | f | plperlu_call_handler | plperlu_inline_handler | plperlu_validator | $libdir/plperl | plpython3u | f | f | plpython3_call_handler | plpython3_inline_handler | plpython3_validator | $libdir/plpython3 | (6 rows) argosrm=# \q marcin@carbon2:~$ psql -U pgsql -h 192.168.89.64 template1 psql (12.4 (Ubuntu 12.4-1)) Type "help" for help. template1=# select * from pg_pltemplate ; tmplname | tmpltrusted | tmpldbacreate | tmplhandler | tmplinline | tmplvalidator | tmpllibrary | tmplacl ------------+-------------+---------------+------------------------+--------------------------+---------------------+-------------------+--------- plpgsql | t | t | plpgsql_call_handler | plpgsql_inline_handler | plpgsql_validator | $libdir/plpgsql | pltcl | t | t | pltcl_call_handler | | | $libdir/pltcl | pltclu | f | f | pltclu_call_handler | | | $libdir/pltcl | plperl | t | t | plperl_call_handler | plperl_inline_handler | plperl_validator | $libdir/plperl | plperlu | f | f | plperlu_call_handler | plperlu_inline_handler | plperlu_validator | $libdir/plperl | plpython3u | f | f | plpython3_call_handler | plpython3_inline_handler | plpython3_validator | $libdir/plpython3 | (6 rows) what can I do next ? Thx Marcin Od: "Adrian Klaver" <adrian.kla...@aklaver.com> Do: "Devrim Gündüz" <dev...@gunduz.org>, "Tom Lane" <t...@sss.pgh.pa.us> DW: "Marcin Giedz" <marcin.gi...@arise.pl>, "pgsql-general" <pgsql-general@lists.postgresql.org> Wysłane: wtorek, 17 listopad 2020 23:30:44 Temat: Re: pg_upgrade from 12 to 13 failes with plpython2 On 11/17/20 2:17 PM, Devrim Gündüz wrote: > > Hi, > > On Tue, 2020-11-17 at 16:23 -0500, Tom Lane wrote: >> You're confusing what the source code can do (which is what the >> manual documents) versus what individual packagers choose to support. >> The packagers frequently don't have a lot of choice in the matter; >> once their platform drops python2, they can't support plpython2. > First let me say: 1) I don't use Python 2 anymore. 2) I have converted my plpython(2)u functions to plpythonu3u 3) I don't use RH family distros. > Well, CentOS 8 "supports" PY2, however given that Christoph also > dropped PY2 support in Debian packages as of PostgreSQL 12 [1], and > given that *Python 2 is unsupported* anyway, I just wanted to drop > support at this point. Read that sentence again and see the inherent disconnect between the beginning and end. As a packager you are in charge of how the packaging is done. Still announcing a change that effectively nullifies the documentation would to me be something that should be announced somewhere else than a list that I'm guessing 99% of the users don't read. > > FWIW, older PostgreSQL major versions still have PY 2 support. This is > for PostgreSQL 13 only. > > [1] : > https://www.postgresql.org/message-id/20200522080114.GA449430%40msg.df7cb.de > > Regards, > -- Adrian Klaver adrian.kla...@aklaver.com -- Pozdrawiam Marcin Giedz Wiceprezes Zarządu ARISE Sp. z o.o. mob. +48 606 673 977 mail: marcin.gi...@arise.pl Al. Solidarności 117 00-140 Warszawa tel. +48 (22) 440 56 20 fax +48 (22) 440 56 22 http://www.arise.pl Grupa ARISE: ARISE Sp. z o.o. (podmiot dominujący), ARISE Services S.A., Al. Solidarności 117, 00-140 Warszawa, Sąd Rejonowy dla m. st. Warszawy w Warszawie XII Wydział Gospodarczy Krajowego Rejestru Sądowego, KRS 0000316860, REGON 141595449, NIP 5272590610, kapitał zakładowy wpłacony 250,000.00 zł.
