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?
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
