FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
Hi Team, i have installed postgresql 13 using packages/tried same using lower versions as well, but replication not working, getting below error. 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.
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@node2 ~]# openssl version OpenSSL 1.0.1e-fips 11 Feb 2013 [root@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@node2 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.2 (Maipo) [root@node2 ~]# On Sat, Dec 19, 2020 at 9:02 PM Adrian Klaver 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@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.kla...@aklaver.com >
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. [root@node2 ~]# openssl version OpenSSL 1.0.1e-fips 11 Feb 2013 [root@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@node2 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.2 (Maipo) [root@node2 ~]# On Sat, Dec 19, 2020 at 10:18 PM Tom Lane wrote: > Rambabu V writes: > > i have installed postgresql 13 using packages/tried same using lower > > versions as well, but replication not working, getting below error. > > > 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 > > Apparently this copy of libpq was built against a newer version of > OpenSSL than what you have installed locally. The man page for > X509_get_signature_nid says it was added in OpenSSL 1.0.2, in case that > helps. You need to find or build a version of Postgres that's intended > for your specific platform version. Alternatively, maybe you would be > better off moving to a newer platform version, or at least installing > a newer OpenSSL version. Anything older than 1.0.1 is considered > outright insecure these days. > > regards, tom lane >
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
Hi Team, below is the link im getting packages. https://www.postgresql.org/download/linux/redhat/ On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver wrote: > On 12/19/20 4:53 PM, Rambabu V wrote: > > 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@node2 ~]# openssl version > > OpenSSL 1.0.1e-fips 11 Feb 2013 > > [root@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@node2 ~]# cat /etc/redhat-release > > Red Hat Enterprise Linux Server release 7.2 (Maipo) > > [root@node2 ~]# > > > > Where are you getting the packages? > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
