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/
postg...@sydcosausdd001.enterprisenet.org:/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.kla...@aklaver.com


Reply via email to