[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Error while upgrading from v12 to v13
From:       shashidhar Reddy <shashidharreddy001 () gmail ! com>
Date:       2022-10-29 14:45:33
Message-ID: CAH=zU4v4eLG1eCsjC-CJaWPQxx03C4J1xCqrmnmdHaxGOus_1A () mail ! gmail ! com
[Download RAW message or body]

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.samu@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 <shashidharreddy001@gmail.com> ezt =C3=ADrta (id=C5=91po=
nt: 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. Ca=
n
>> 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
>>
>

[Attachment #3 (text/html)]

<div dir="auto">I have dropped the function on all databases on version 12,but while \
upgrading I am still getting the  same error</div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Sat, 29 Oct, 2022, 7:56 pm Imre Samu, &lt;<a \
href="mailto:pella.samu@gmail.com">pella.samu@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">&gt; ERROR:   could \
not find function &quot;pl_profiler_enable&quot; in file<br><div><br></div><div>maybe \
obsolete function?</div><div><br></div><div><font face="monospace">-- Drop obsolete \
function<br>DROP FUNCTION pl_profiler_enable(bool);</font><br></div><div><a \
href="https://github.com/bigsql/plprofiler/blob/master/plprofiler--3.5--4.0.sql" \
target="_blank" rel="noreferrer">https://github.com/bigsql/plprofiler/blob/master/plprofiler--3.5--4.0.sql</a><br></div><div><br></div><div>Regards,</div><div> \
Imre</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">shashidhar Reddy &lt;<a href="mailto:shashidharreddy001@gmail.com" \
target="_blank" rel="noreferrer">shashidharreddy001@gmail.com</a>&gt; ezt írta \
(időpont: 2022. okt. 29., Szo, 13:40):<br></div><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br clear="all"><div>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.</div><div><br></div><div>  error: could not execute query: ERROR:   could not \
find function &quot;pl_profiler_enable&quot; in \
file<br>&quot;/usr/lib/postgresql/13/lib/plprofiler.so&quot;<br>Command was: CREATE \
FUNCTION &quot;public&quot;.&quot;pl_profiler_enable&quot;(&quot;enabled&quot; \
boolean) RETURNS boolean<br>      LANGUAGE &quot;c&quot;<br>      AS \
&#39;$libdir/plprofiler&#39;, &#39;pl_profiler_enable&#39;;<br></div><div \
dir="ltr">Shashidhar</div></div> </blockquote></div>
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]