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

Hi Team,

below are the os versions details. standalone machine running without any
issues, coming to replication not working, even i tried from postgresql 10
onwards as well, no other versions running in the server now.

[root(at)node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root(at)node2 ~]# uname -a
Linux node2 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015
x86_64 x86_64 x86_64 GNU/Linux
[root(at)node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root(at)node2 ~]#

On Sat, Dec 19, 2020 at 9:02 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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(at)localhost log]# which libpqwalreceiver.so
> > /usr/bin/libpqwalreceiver.so
> > [root(at)localhost log]# which libpq.so.5
> > /usr/bin/libpq.so.5
> >
> > [postgres(at)localhost ~]$ export LD_LIBRARY_PATH=$PATH:/usr/pgsql-13/lib/
> > [postgres(at)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(dot)klaver(at)aklaver(dot)com
>