Re: perl path issue

Hi Adrian,

Please find the details,

==> 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)
libm.so.6 => /lib64/libm.so.6 (0x00007f5ecd8d4000)
libc.so.6 => /lib64/libc.so.6 (0x00007f5ecd507000)
libssl.so.1.0.0 => /usr/lib64/perl5/CORE/libssl.so.1.0.0
(0x00007f5ecd297000)
libcrypto.so.1.0.0 => /usr/lib64/perl5/CORE/libcrypto.so.1.0.0
(0x00007f5ecce5d000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2
(0x00007f5eccc10000)
libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f5ecc9b1000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f5ecc795000)
/lib64/ld-linux-x86-64.so.2 (0x00007f5ece056000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f5ecc591000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f5ecc2a8000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f5ecc075000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f5ecbe71000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0
(0x00007f5ecbc61000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f5ecba5d000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f5ecb844000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f5ecb635000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f5ecb418000)
libssl.so.10 => /lib64/libssl.so.10 (0x00007f5ecb1a6000)
libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f5ecad45000)
libssl3.so => /lib64/libssl3.so (0x00007f5ecaaf3000)
libsmime3.so => /lib64/libsmime3.so (0x00007f5eca8cc000)
libnss3.so => /lib64/libnss3.so (0x00007f5eca59f000)
libnssutil3.so => /lib64/libnssutil3.so (0x00007f5eca370000)
libplds4.so => /lib64/libplds4.so (0x00007f5eca16c000)
libplc4.so => /lib64/libplc4.so (0x00007f5ec9f67000)
libnspr4.so => /lib64/libnspr4.so (0x00007f5ec9d29000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f5ec9b02000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f5ec98cb000)
libz.so.1 => /lib64/libz.so.1 (0x00007f5ec96b5000)
librt.so.1 => /lib64/librt.so.1 (0x00007f5ec94ad000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f5ec924b000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007f5ec9048000)
postgres(at)sydcosausd001(dot)enterprisenet(dot)org:/home/postgres

On Mon, May 13, 2019 at 8:04 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 5/13/19 7:03 AM, Prakash Ramakrishnan wrote:
> > Hi Adrian,
> >
> > I did in pgbackrest installation below commands in prod server.
> >
> > yum install
> >
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rp
> > <
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
> >m
> >
> >
> > yum install pgbackrest
> >
> >
> > and prod server backup working fine .
> >
> > prod and dev file system mount points is different naming conversation.
> >
> > so we have taken the restore directly using to prod .
>
> Hmm. I would follow Achilleas's suggestion and do:
>
> ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--

Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426