Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"

Поиск
Список
Период
Сортировка
От Marco Aurelio
Тема Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"
Дата
Msg-id CA+bywzNtW=TgvAydODSSowy1rV8rd7MRXJ7+oKB59ezwa_+GaQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"
Список pgsql-general
Dear Friends,

I have a Freebsd 13.2 server where I installed postgresql 16.1 via source code, I installed the pgcrypto extension with the gmake install command without error messages, but when trying to create the extension in a database I receive the following message:
ERROR: could not load library "/usr/local/pgsql16/lib/pgcrypto.so": /usr/local/pgsql16/lib/pgcrypto.so: Undefined symbol "EVP_bf_ecb"

Freebsd 13.2 has 2 versions of openssl installed, one base and the other via pkg, the base version is:
OpenSSL 1.1.1t-freebsd 7 Feb 2023

while the version installed via pkg is:
OpenSSL 3.0.12 24 Oct 2023 (Library: OpenSSL 3.0.12 24 Oct 2023)

When I run ./configure I see in config.log that it is always using the base version of Freebsd.

How to resolve this?


Marco Aurélio Ventura da Silva
Analista de Sistemas / Desenvolvedor
Prodata Informática e Cadastro LTDA
(33) 3322-6363

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"