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
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?
PostgreSQL extensions are compiled against one specific major release - so you cannot use pgq for 9.6 in Postgres 14. You should install pgq for PostgreSQL 14.