From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | rob stan <aslicokay(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgres Version Upgrade to 14.1 error |
Date: | 2022-02-04 06:16:47 |
Message-ID: | CAFj8pRAcwKfJ3+TCuLHmjE4VQLt+E+=zdp5iL5T4RBQ3Y8QV2A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
pá 4. 2. 2022 v 7:02 odesílatel rob stan <aslicokay(at)gmail(dot)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!
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias Apitz | 2022-02-04 08:29:05 | Re: sort order for UTF-8 char column with Japanese UTF-8 |
Previous Message | rob stan | 2022-02-04 06:02:02 | Postgres Version Upgrade to 14.1 error |