Re: Error while upgrading from v12 to v13

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(dot)samu(at)gmail(dot)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 <shashidharreddy001(at)gmail(dot)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
>>
>