Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication

soumitra

Hi , 
When use yum installed PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication, the logs in 
the standby are as follows . 

Is this a bug with  PostgreSQL 11.2 for streaming replication ? Is there any way out or any different release is there ? Please suggest .  

Postgres version : 
 PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

Os version : 
Red Hat Enterprise Linux Server release 7.2 (Maipo)

2019-04-17 10:15:48.752 IST [15386] LOG:  database system is ready to accept read only connections
2019-04-17 10:15:48.755 IST [15393] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:48.758 IST [15394] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:53.764 IST [15398] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:58.772 IST [15403] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:16:03.776 IST [15408] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference


Same issue reported in below mail chain as well . 


Thanks, 
Soumitra 
Soumitra Bhandary Postgres Database Administrator
Reply | Threaded
Open this post in threaded view
|

Re: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication

Devrim GÜNDÜZ
Hi,

You need to update openssl.

Regards, Devrim

On 17 April 2019 08:12:53 GMT+03:00, soumitra bhandary <[hidden email]> wrote:

Hi , 
When use yum installed PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication, the logs in 
the standby are as follows . 

Is this a bug with  PostgreSQL 11.2 for streaming replication ? Is there any way out or any different release is there ? Please suggest .  

Postgres version : 
 PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

Os version : 
Red Hat Enterprise Linux Server release 7.2 (Maipo)

2019-04-17 10:15:48.752 IST [15386] LOG:  database system is ready to accept read only connections
2019-04-17 10:15:48.755 IST [15393] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:48.758 IST [15394] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:53.764 IST [15398] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:15:58.772 IST [15403] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
2019-04-17 10:16:03.776 IST [15408] FATAL:  could not load library "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference


Same issue reported in below mail chain as well . 


Thanks, 
Soumitra 

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.