I have dropped the function on all databases on version 12,but while upgrading I am still getting the same error
On Sat, 29 Oct, 2022, 7:56 pm Imre Samu, <pella.s...@gmail.com> wrote: > > ERROR: could not find function "pl_profiler_enable" in file > > maybe obsolete function? > > -- Drop obsolete function > DROP FUNCTION pl_profiler_enable(bool); > https://github.com/bigsql/plprofiler/blob/master/plprofiler--3.5--4.0.sql > > Regards, > Imre > > shashidhar Reddy <shashidharreddy...@gmail.com> ezt írta (időpont: 2022. > okt. 29., Szo, 13:40): > >> >> I am getting below error while upgrading postgres from version 12 to 13 >> and not sure how to enable the function before upgrading the cluster. Can >> you please help me to resolve this. >> >> error: could not execute query: ERROR: could not find function >> "pl_profiler_enable" in file >> "/usr/lib/postgresql/13/lib/plprofiler.so" >> Command was: CREATE FUNCTION "public"."pl_profiler_enable"("enabled" >> boolean) RETURNS boolean >> LANGUAGE "c" >> AS '$libdir/plprofiler', 'pl_profiler_enable'; >> Shashidhar >> >