From: | rob stan <aslicokay(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Postgres Version Upgrade to 14.1 error |
Date: | 2022-02-04 06:02:02 |
Message-ID: | CAGADRUEJnyXm6-aYde8+5WrDVMqp0BPuqWFeL9R_vGLPo205Dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2022-02-04 06:16:47 | Re: Postgres Version Upgrade to 14.1 error |
Previous Message | Merlin Moncure | 2022-02-04 04:32:45 | Re: Can Postgres beat Oracle for regexp_count? |