Postgres Pro
Downloads
Home   >   mailing lists

Re: Error while upgrading from v12 to v13 - Mailing list pgsql-general

From shashidhar Reddy
Subject Re: Error while upgrading from v12 to v13
Date
Msg-id CAH=zU4v4eLG1eCsjC-CJaWPQxx03C4J1xCqrmnmdHaxGOus_1A@mail.gmail.com
Whole thread Raw
In response to Re: Error while upgrading from v12 to v13  (Imre Samu <pella.samu@gmail.com>)
List pgsql-general
Tree view
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);

Regards,
 Imre

shashidhar Reddy <shashidharreddy001@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

pgsql-general by date:

Previous
From: Imre Samu
Date:
Subject: Re: Error while upgrading from v12 to v13
Next
From: "jacktby@gmail.com"
Date:
Subject: Does it equal to execute "CREATE ACCESS METHOD"?