Postgres Version Upgrade to 14.1 error

Поиск
Список
Период
Сортировка
От rob stan
Тема Postgres Version Upgrade to 14.1 error
Дата
Msg-id CAGADRUEJnyXm6-aYde8+5WrDVMqp0BPuqWFeL9R_vGLPo205Dw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres Version Upgrade to 14.1 error  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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!

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Can Postgres beat Oracle for regexp_count?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Postgres Version Upgrade to 14.1 error