Обсуждение: BUG #15799: Create extension postgres_fdw failed

Поиск
Список
Период
Сортировка

BUG #15799: Create extension postgres_fdw failed

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      15799
Logged by:          Yury Davydov
Email address:      yury.davydov@exoduspoint.com
PostgreSQL version: 10.6
Operating system:   Red Hat 7.6
Description:

create extension postgres_fdw;
ERROR:  could not load library "/usr/pgsql-10/lib/postgres_fdw.so":
/usr/pgsql-10/lib/postgres_fdw.so: undefined symbol: change_plan_targetlist


Re: BUG #15799: Create extension postgres_fdw failed

От
Tom Lane
Дата:
PG Bug reporting form <noreply@postgresql.org> writes:
> create extension postgres_fdw;
> ERROR:  could not load library "/usr/pgsql-10/lib/postgres_fdw.so":
> /usr/pgsql-10/lib/postgres_fdw.so: undefined symbol: change_plan_targetlist

This looks like a version mismatch problem --- your postgres_fdw is newer
than your server (possibly just a minor release newer, but still newer).

It's unfortunate that the error message isn't more on-point, but we don't
have enough control over the dynamic linker to make it so.

            regards, tom lane



RE: BUG #15799: Create extension postgres_fdw failed

От
"Davydov, Yury"
Дата:
Thank you. I bounced the server second time and it worked

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Friday, May 10, 2019 3:52 PM
To: Davydov, Yury <Yury.Davydov@exoduspoint.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15799: Create extension postgres_fdw failed

PG Bug reporting form <noreply@postgresql.org> writes:
> create extension postgres_fdw;
> ERROR:  could not load library "/usr/pgsql-10/lib/postgres_fdw.so":
> /usr/pgsql-10/lib/postgres_fdw.so: undefined symbol:
> change_plan_targetlist

This looks like a version mismatch problem --- your postgres_fdw is newer than your server (possibly just a minor
releasenewer, but still newer). 

It's unfortunate that the error message isn't more on-point, but we don't have enough control over the dynamic linker
tomake it so. 

regards, tom lane

The information contained in this message and its attachments is intended only for the private and confidential use of
theintended recipient(s). If you are not the intended recipient (or have received this e-mail in error) please notify
thesender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in
thise-mail is strictly prohibited. By accepting and retaining this email, you agree not to disseminate it in any form
toany person and not to alter it in any way. Thank you.