Search Postgresql Archives

Re: Error while upgrading from v12 to v13

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux