Thread: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Rambabu V
Date:
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
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
/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/
[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
From
Adrian Klaver
Date:
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
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Tom Lane
Date:
Rambabu V <ram.wissen@gmail.com> 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
From
Rambabu V
Date:
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.
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 <adrian.klaver@aklaver.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@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
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Rambabu V
Date:
Hi Team,
[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 ~]#
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.
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 <tgl@sss.pgh.pa.us> wrote:
Rambabu V <ram.wissen@gmail.com> 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
From
Adrian Klaver
Date:
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.klaver@aklaver.com
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Rambabu V
Date:
On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <adrian.klaver@aklaver.com> 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.klaver@aklaver.com
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Adrian Klaver
Date:
On 12/19/20 5:05 PM, Rambabu V wrote: > Hi Team, > > below is the link im getting packages. > > https://www.postgresql.org/download/linux/redhat/ > <https://www.postgresql.org/download/linux/redhat/> This was fixed here: https://redmine.postgresql.org/issues/4509 You will need community account to see issue. Relevant parts: 2019-07-24 "After some analysis we found that the issue was the addition of `X509_get_signature_nid` function calls in PG11, and the fact that the customer was still on openssl-libs 1.0.1e, which doesn't have that function implemented, and not the latest 1.0.2k available. For that reason the postgresql11-libs should have a dependency so openssl-libs 1.0.2 or better is installed." ... 2019-08-30 "I updated PostgreSQL 10+ spec files: https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=86f8778e077d250e9b3c0e695d5cc297057c511a These changes will appear in next minor updates. " Have you looked at this announcement?: https://yum.postgresql.org/news/new-repo-rpms-released/ > > On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication
From
Devrim Gündüz
Date:
Hi, On Sun, 2020-12-20 at 06:23 +0530, Rambabu V wrote: > [root@node2 ~]# cat /etc/redhat-release > Red Hat Enterprise Linux Server release 7.2 (Maipo) IIRC RHEL 7 RPMs support RHEL 7.6+. Please update. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR