| 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: | Whole Thread | Raw Message | 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? |