From: | rob stan <aslicokay(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(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 20:17:00 |
Message-ID: | CAGADRUFJDgMXPBggt=Yk81Fj0Q-FaFzOdfo856a8gfhUVfYSsg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)stehule(at)gmail(dot)com>, 4 Şub 2022 Cum, 01:17 tarihinde
şunu yazdı:
> 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 | Adrian Klaver | 2022-02-04 20:23:48 | Re: Postgres Version Upgrade to 14.1 error |
Previous Message | Tomas Vondra | 2022-02-04 17:01:20 | Re: increasing effective_cache_size slows down join queries by a factor of 4000x |