Re: perl path issue - Mailing list pgsql-general
| From | Prakash Ramakrishnan |
|---|---|
| Subject | Re: perl path issue |
| Date | |
| Msg-id | CAA2eZXwSZ4Teuzh9d8eaPjQobxe_At18HGYNRPsr4RJBHNnWfg@mail.gmail.com Whole thread Raw |
| In response to | Re: perl path issue (Ravi Krishna <ravi_krishna@aol.com>) |
| Responses |
Re: perl path issue
|
| List | pgsql-general |
Hi Ravi,
/usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:/opt/rh/rh-perl526/root/usr/lib64:/usr/lib64/perl5/CORE:/opt/edb/languagepack-10/Perl-5.24/lib/CORE
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> 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 --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' 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/0xc54528/pgBackRest/Db.pm line 10.
at /loader/0xc54528/pgBackRest/Main.pm line 12.
I tried manually export the lib path multiple times not working.
prod:
==> echo $LD_LIBRARY_PATH
/usr/lib64/perl5/CORE:/opt/app/PostgreSQL/10/lib:/opt/edb/languagepack-10/Perl-5.24/lib/CORE:/opt/app/PostgreSQL/10/lib
/usr/lib64/perl5/CORE:/opt/app/PostgreSQL/10/lib:/opt/edb/languagepack-10/Perl-5.24/lib/CORE:/opt/app/PostgreSQL/10/lib
dev --- ==> echo $LD_LIBRARY_PATH
/usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:/opt/rh/rh-perl526/root/usr/lib64:/usr/lib64/perl5/CORE:/opt/edb/languagepack-10/Perl-5.24/lib/CORE
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> export LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:/opt/app/PostgreSQL/10/lib:/opt/edb/languagepack-10/Perl-5.24/lib/CORE:/opt/app/PostgreSQL/10/lib
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> echo $LD_LIBRARY_PATH
postgres@sydcosausd001.enterprisenet.org:/home/postgres
==> echo $LD_LIBRARY_PATH
Password:
ERROR [124]: : remote process on '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/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> 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
pgsql-general by date: