On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
Hi Team,
We having perl issue for while during restore operation for using
pgbackrest backup tool can you please do the needful.
Looks to me like the Postgres client library libpq is not installed or
cannot be found on this machine.
You will need to verify using your package manager.
2019-05-08 18:42:09.415 P00 INFO: restore command begin 2.13:
--db-include=A4_Copy --log-level-console=info
--pg1-path=/Postgres/prakash_pgbackrest --process-max=2
--repo1-host=sydcosacpp001.enterprisenet.org
<http://sydcosacpp001.enterprisenet.org>
--repo1-host-config=/etc/pgbackrest.conf --repo1-host-user=postgres
--repo1-path=/pgBACKUP/A4_ sydcosacpp001 /backup/A4_
sydcosacpp001 --stanza=A4_s sydcosacpp001 1
2019-05-08 18:42:15.082 P00 ERROR: [124]: remote process on '
sydcosacpp001 .enterprisenet.org <http://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/0x226a528/pgBackRest/Db.pm line 10.
at
/loader/0x226a528/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
==> cd /usr/lib64/perl5/
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/usr/lib64/perl5
==> ls
arybase.pm <http://arybase.pm> bits CORE
Fcntl.pm _h2ph_pre.ph <http://h2ph_pre.ph> lib.pm
<http://lib.pm> NDBM_File.pm perllocal.pod stdarg.ph
<http://stdarg.ph> syslimits.ph <http://syslimits.ph> Unicode
asm B.pm Devel features.ph <http://features.ph>
Hash linux ODBM_File.pm POSIX.pm stdc-predef.ph
<http://stdc-predef.ph> syslog.ph <http://syslog.ph> vendor_perl
asm-generic Config_git.pl Digest File I18N
machine Opcode.pm POSIX.pod stddef.ph <http://stddef.ph>
Text wait.ph <http://wait.ph>
attributes.pm <http://attributes.pm> Config_heavy.pl DynaLoader.pm
Filter IO Math O.pm re.pm <http://re.pm>
sys Tie xlocale.ph <http://xlocale.ph>
auto Config.pm endian.ph <http://endian.ph> GDBM_File.pm
IO.pm MIME ops.pm <http://ops.pm> SDBM_File.pm Sys
Time
B Config.pod Errno.pm gnu IPC mro.pm
<http://mro.pm> PerlIO signal.ph <http://signal.ph> syscall.ph
<http://syscall.ph> time.ph <http://time.ph>
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
call : +91-8939599426
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
