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

Marcin Giedz <marcin.gi...@arise.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 


Reply via email to