Hi Ravi,
Please find the below details,
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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
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
postgres@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/home/postgres
On Mon, May 13, 2019 at 3:20 PM Ravi Krishna <ravi_krishna@xxxxxxx> wrote:
> and perl DBD also installed but it cant load that is the issue please advise me.
what is the output of LD_LIBRARY_PATH on both dev and prod
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426