Hi pá 4. 2. 2022 v 7:02 odesílatel rob stan <aslico...@gmail.com> napsal:
> 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? > 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. Regards Pavel > Thanks! >