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!

Reply via email to