Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication

On 12/19/20 2:54 AM, Rambabu V wrote:
> Hi Team,
> 
> i have installed postgresql 13 using packages/tried same using lower 
> versions as well, but replication not working, getting below error.

What OS and version?

Where did you get packages?

Do you have other versions of Postgres running on this machine?

> 
> 2020-12-19 02:48:22.346 PST [3574] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:22.350 PST [3575] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:27.362 PST [3576] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 2020-12-19 02:48:32.366 PST [3580] FATAL:  could not load library 
> "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5: 
> symbol X509_get_signature_nid, version libcrypto.so.10 not defined in 
> file libcrypto.so.10 with link time reference
> 
> even though i have exported LD_LIBRARY_PATH and created link also.
> 
> [root@localhost log]# which libpqwalreceiver.so
> /usr/bin/libpqwalreceiver.so
> [root@localhost log]# which libpq.so.5
> /usr/bin/libpq.so.5
> 
> [postgres@localhost ~]$ export LD_LIBRARY_PATH=$PATH:/usr/pgsql-13/lib/
> [postgres@localhost ~]$ echo $LD_LIBRARY_PATH
>
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/postgres/.local/bin:/home/postgres/bin:/usr/pgsql-13/lib/
> 
> every version has the same issue with packages, please help me to 
> resolve this issue.


-- 
Adrian Klaver
adrian.klaver@aklaver.com