On 5/10/19 2:24 AM, Prakash Ramakrishnan wrote:
Hi Adrian,
Some perl path is not working here please find the below details,
How did you install/build pgbackrest?
The basic issue as I see it is that pgBackRest and your EDB Postgres are
living in separate worlds as far as each is concerned. To fix this you
have two options as I see it:
1) To reconcile then you will need to either consult the pgBackRest or
EDB folks for a solution, as I use neither and don't know how to make
then play well together.
2) Convert your Postgres server from using the EDB installer to using
the native packages. This is going to have to happen anyway going
forward off version 10. I would probably stick to the community packages
here:
https://www.postgresql.org/download/linux/redhat/
==> ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so
linux-vdso.so.1 => (0x00007ffccf4a3000)
* libperl.so =>
/opt/edb/languagepack-10/Perl-5.24/lib/CORE/libperl.so (0x00007f9dac941000)*
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9dac725000)
libc.so.6 => /lib64/libc.so.6 (0x00007f9dac358000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9dac13e000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f9dabf3a000)
libm.so.6 => /lib64/libm.so.6 (0x00007f9dabc38000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f9daba01000)
libutil.so.1 => /lib64/libutil.so.1 (0x00007f9dab7fe000)
/lib64/ld-linux-x86-64.so.2 (0x00007f9dacf44000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f9dab5fb000)
but the pgbackrest need this perl path i thin - libperl.so =>
/usr/lib64/perl5/CORE/libperl.so (0x00007f955333b000)
still we getting the error,
==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info
--db-path=/Postgres/prakash_pgbackrest --delta --process-max=2
--db-include=A4_Copy restore
--repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001
2019-05-10 19:23:39.525 P00 INFO: restore command begin 2.13:
--db-include=A4_Copy --delta --log-level-console=info
--pg1-path=/Postgres/prakash_pgbackrest --process-max=2
--repo1-host=sydcosafpp001.enterprisenet.org
<http://sydcosafpp001.enterprisenet.org>
--repo1-host-config=/etc/pgbackrest.conf --repo1-host-user=postgres
--repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001
--stanza=A4_sydcosafpp001
Password:
ERROR [124]: : remote process on 'sydcosafpp001.enterprisenet.org
<http://sydcosafpp001.enterprisenet.org>' terminated unexpectedly [124]:
ERROR: [124]: process terminated due to an unhandled exception:
*Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so' for module
DBD::Pg: libpq.so.5: cannot open shared object file: No such file or
directory at /usr/lib64/perl5/DynaLoader.pm line 190.*
at /loader/0x103a528/pgBackRest/Db.pm line 10.
at /loader/0x103a528/pgBackRest/Main.pm line 12.
pgBackRest::Main::__ANON__('Can\'t load
\'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
/usr/share/perl5/vendor_perl/Carp.pm line 100
Carp::croak('Can\'t load
\'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
/usr/lib64/perl5/DynaLoader.pm line 98
DynaLoader::croak('Can\'t load
\'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
/usr/lib64/perl5/DynaLoader.pm line 190
DynaLoader::bootstrap('DBD::Pg', 'version=HASH(0x19b1a68)')
called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73
require DBD/Pg.pm called at /loader/0x103a528/pgBackRest/Db.pm
line 10
pgBackRest::Db::BEGIN() called at
/usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
require pgBackRest/Db.pm called at
/loader/0x103a528/pgBackRest/Archive/Common.pm line 16
pgBackRest::Archive::Common::BEGIN() called at
/usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
require pgBackRest/Archive/Common.pm called at
/loader/0x103a528/pgBackRest/Archive/Get/File.pm line 15
pgBackRest::Archive::Get::File::BEGIN() called at
/usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
require pgBackRest/Archive/Get/File.pm called at
/loader/0x103a528/pgBackRest/Protocol/Remote/Minion.pm line 17
pgBackRest::Protocol::Remote::Minion::BEGIN() called at
/usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
require pgBackRest/Protocol/Remote/Minion.pm called at
/loader/0x103a528/pgBackRest/Main.pm line 118
eval {...} called at /loader/0x103a528/pgBackRest/Main.pm line 286
pgBackRest::Main::main('remote') called at (eval 269) line 1
eval '($iResult, $bErrorC, $strMessage) =
pgBackRest::Main::main(\'remote\')
;' called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
can you please help this we are struggling to solve the issue,
Regards,
Prakash.R
On Thu, May 9, 2019 at 10:58 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote:
> Hi David,
>
> I did the installation for using postgresql 10.4 version edb
standard
> edition.so again need to run the yum command or please advise me .
I don't have time to go through the below, but some issues filed at
pgbackrest about using EDB installed database:
https://github.com/pgbackrest/pgbackrest/issues?q=is%3Aissue+edb+is%3Aclosed
>
>
> Regards,
> Prakash.R
>
> On Thu, May 9, 2019, 22:24 David Steele <david@xxxxxxxxxxxxx
<mailto:david@xxxxxxxxxxxxx>
> <mailto:david@xxxxxxxxxxxxx <mailto:david@xxxxxxxxxxxxx>>> wrote:
>
> On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
> > Hi Adrian,
> >
> > I don't know about that client libraries can you please
explain
> or share
> > me the command I will show you the output and we need the
> solution for
> > this pgbackrest issue .
>
> yum install postgresql10
>
> should do it, but I thought pqlib was installed with the
server as well.
> Perhaps not.
>
> --
> -David
> david@xxxxxxxxxxxxx <mailto:david@xxxxxxxxxxxxx>
<mailto:david@xxxxxxxxxxxxx <mailto:david@xxxxxxxxxxxxx>>
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
call : +91-8939599426
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
