unable to import module: /usr/local/greenplum-db-xx/lib/libpq.so.5:

Products

• VMware Tanzu Greenplum

Issue/Introduction

after a new installation of gpdb binary file, gpstate report error:

Error: unable to import module: /usr/local/greenplum-db-6.21.0/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference

Environment

Product Version: 6.21

Resolution

The libpq has dependency on libcrypto library file. In this case, some libcrypto library file is missing. Reinstall the openssl package will fix this.

yum install openssl