Error while upgrading from v12 to v13
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
Any help in this?
On Sat, 29 Oct, 2022, 5:09 pm shashidhar Reddy, <
shashidharreddy001@gmail.com> wrote:
Show quoted text
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
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 írta (időpont: 2022.
okt. 29., Szo, 13:40):
Show quoted text
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
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:
Show quoted text
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.sqlRegards,
Imreshashidhar 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