Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres Version Upgrade to 14.1 error

Postgres Version Upgrade to 14.1 error

From
rob stan
Date:
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!

Re: Postgres Version Upgrade to 14.1 error

From
Pavel Stehule
Date:
Hi

pá 4. 2. 2022 v 7:02 odesílatel rob stan <aslicokay@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!

Re: Postgres Version Upgrade to 14.1 error

From
rob stan
Date:
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.stehule@gmail.com>, 4 Şub 2022 Cum, 01:17 tarihinde şunu yazdı:
Hi

pá 4. 2. 2022 v 7:02 odesílatel rob stan <aslicokay@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!

Re: Postgres Version Upgrade to 14.1 error

From
Adrian Klaver
Date:
On 2/4/22 12:17, rob stan wrote:
> 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.

 From here:

https://github.com/pgq/pgq/releases

it looks like it only officially goes to version 13.



-- 
Adrian Klaver
adrian.klaver@aklaver.com