Thanks Pavel. Do you know pgq is compatible with postgresql-server-dev-14 packages? I couldn't see any requirements or something documented for pgq and postgres 14.
Pavel Stehule <pavel.steh...@gmail.com>, 4 Şub 2022 Cum, 01:17 tarihinde şunu yazdı: > 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! >> >
