Postgres Version Upgrade to 14.1 error

From: rob stan <aslicokay(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Postgres Version Upgrade to 14.1 error
Date: 2022-02-04 06:02:02
Message-ID: CAGADRUEJnyXm6-aYde8+5WrDVMqp0BPuqWFeL9R_vGLPo205Dw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We have "pgq" extensions on our clusters when I am trying to upgrade from
9.6.24 to 14.1 with pg_upgrade --link method, i am getting error;

First i was getting this error ;

could not load library "$libdir/pgq_lowlevel": ERROR: could not access
file "$libdir/pgq_lowlevel": No such file or directory
could not load library "$libdir/pgq_triggers": ERROR: could not access
file "$libdir/pgq_triggers": No such file or directory

After i copied pgq files to extension directory;
/usr/lib/postgresql/9.6/lib# cp pgq_lowlevel.so
/usr/lib/postgresql/14.1/lib/
/usr/lib/postgresql/9.6/lib# cp pgq_triggers.so
/usr/lib/postgresql/14.1/lib/

I am getting this error message;
could not load library "$libdir/pgq_triggers": ERROR: could not load
library "/usr/lib/postgresql/14.1/lib/pgq_triggers.so":
/usr/lib/postgresql/14.1/lib/pgq_triggers.so: undefined symbol: elog_finish

Do you have any ideas on how to solve this problem?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2022-02-04 06:16:47 Re: Postgres Version Upgrade to 14.1 error
Previous Message Merlin Moncure 2022-02-04 04:32:45 Re: Can Postgres beat Oracle for regexp_count?