Re: perl path issue - Mailing list pgsql-general

On 5/13/19 8:14 AM, Prakash Ramakrishnan wrote:
> Hi Ravi,
> 
> I tried manually export the lib path multiple times not working.
> 

> ==> 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-13 19:55:05.954 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]: 

Trying to figure out above:

sydcosausd001.enterprisenet.org is your dev

sydcosafpp001.enterprisenet.org  is your prod

Correct?

You are trying to run the pgBackRest on the dev machine, so why is there 
a remote process failure on the prod?


> 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/0xc54528/pgBackRest/Db.pm line 10.
>         at /loader/0xc54528/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
> 
> 
> Regards,
> Prakash.R
> 
> On Mon, May 13, 2019 at 8:39 PM Ravi Krishna <ravi_krishna@aol.com 
> <mailto:ravi_krishna@aol.com>> wrote:
> 
>      >
>      > ==> ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so
>      >         linux-vdso.so.1 =>  (0x00007fffddd8f000)
>      >         libpq.so.5 => /usr/lib64/perl5/CORE/libpq.so.5
>     (0x00007f5ecdbd6000)
>                                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
>     I may be wrong, but is the above path in the LD_LIBRARY_PATH. Why do
>     you expect it to be picked auto magically.
> 
> 
> 
> 
> -- 
> 
> 
> 
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On 
> call : +91-8939599426


-- 
Adrian Klaver
adrian.klaver@aklaver.com