Re: pg_upgrade from 12 to 13 failes with plpython2

so look at this:

marcin(at)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(at)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(at)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(at)sss(dot)pgh(dot)pa(dot)us>
Do: "Marcin Giedz" <marcin(dot)giedz(at)arise(dot)pl>
DW: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, "Magnus Hagander" <magnus(at)hagander(dot)net>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>, "Devrim Gündüz" <devrim(at)gunduz(dot)org>, "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
Wysłane: środa, 18 listopad 2020 19:08:25
Temat: Re: pg_upgrade from 12 to 13 failes with plpython2

Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl> 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