Re: pg_upgrade from 12 to 13 failes with plpython2

[Marcin Giedz <marcin.giedz@xxxxxxxx>]

so look at this:

marcin@carbon2:~$ psql -U pgsql -h 192.168.89.64 postgres
psql (12.4 (Ubuntu 12.4-1), server 12.5)
Type "help" for help.

postgres=# drop extension plpython;
ERROR:  extension "plpython" does not exist
postgres=# drop extension plpythonu;
ERROR:  extension "plpythonu" does not exist
postgres=# drop extension plpython2u;
ERROR:  extension "plpython2u" does not exist
postgres=# \q
marcin@carbon2:~$ psql -U pgsql -h 192.168.89.64 template1
psql (12.4 (Ubuntu 12.4-1), server 12.5)
Type "help" for help.

template1=# drop extension plpython2u;
ERROR:  extension "plpython2u" does not exist
template1=# drop extension plpythonu;
ERROR:  extension "plpythonu" does not exist
template1=# drop extension plpython;
ERROR:  extension "plpython" does not exist
template1=# \q
marcin@carbon2:~$ psql -U pgsql -h 192.168.89.64 argosrm
psql (12.4 (Ubuntu 12.4-1), server 12.5)
Type "help" for help.

argosrm=# drop extension plpython;
ERROR:  extension "plpython" does not exist
argosrm=# drop extension plpythonu;
ERROR:  extension "plpythonu" does not exist
argosrm=# drop extension plpython2u;
ERROR:  extension "plpython2u" does not exist

---

Od: "Tom Lane" <tgl@xxxxxxxxxxxxx>
Do: "Marcin Giedz" <marcin.giedz@xxxxxxxx>
DW: "Laurenz Albe" <laurenz.albe@xxxxxxxxxxx>, "Magnus Hagander" <magnus@xxxxxxxxxxxx>, "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>, "Devrim Gündüz" <devrim@xxxxxxxxxx>, "pgsql-general" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Wysłane: środa, 18 listopad 2020 19:08:25
Temat: Re: pg_upgrade from 12 to 13 failes with plpython2

Marcin Giedz <marcin.giedz@xxxxxxxx> writes:
> all DBs checked and no plpython(2u) is found except for plpython3u

I think you also need to make sure you've dropped the plpythonu
and plpython2u extensions in every database.

                        regards, tom lane