Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12

Thanks Tom,

Query helped. After removing the functions below, the upgrade went well.

plpython2_call_handler;
plpython2_inline_handler;
plpython2_validator;

Thanks & Regards,
Raj

On Sun, Mar 7, 2021 at 9:50 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> RAJAMOHAN <garajamohan(at)gmail(dot)com> writes:
> > But the issue is still occurring for me, even though I dropped the
> > *plpython2u* extension and functions which were using the it.
>
> Look through pg_proc for entries mentioning plpython2 in probin, ie
>
> select proname from pg_proc where probin like '%plpython2%';
>
> Another possibility is that you added plpython2 to shared_preload_libraries
> or one of its sibling settings.
>
> regards, tom lane
>