Re: perl path issue

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@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.klaver@aklaver.com