Re: perl path issue - Mailing list pgsql-general

On 5/10/19 2:24 AM, Prakash Ramakrishnan wrote:
> Hi Adrian,
>
> Some perl path is not working here please find the below details,

How did you install/build pgbackrest?

The basic issue as I see it is that pgBackRest and your EDB Postgres are
living in separate worlds as far as each is concerned. To fix this you
have two options as I see it:

1) To reconcile then you will need to either consult the pgBackRest or
EDB folks for a solution, as I use neither and don't know how to make
then play well together.

2) Convert your Postgres server from using the EDB installer to using
the native packages. This is going to have to happen anyway going
forward off version 10. I would probably stick to the community packages
here:

https://www.postgresql.org/download/linux/redhat/


>
> ==> ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so
>          linux-vdso.so.1 =>  (0x00007ffccf4a3000)
> *        libperl.so =>
> /opt/edb/languagepack-10/Perl-5.24/lib/CORE/libperl.so (0x00007f9dac941000)*
>          libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9dac725000)
>          libc.so.6 => /lib64/libc.so.6 (0x00007f9dac358000)
>          libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9dac13e000)
>          libdl.so.2 => /lib64/libdl.so.2 (0x00007f9dabf3a000)
>          libm.so.6 => /lib64/libm.so.6 (0x00007f9dabc38000)
>          libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f9daba01000)
>          libutil.so.1 => /lib64/libutil.so.1 (0x00007f9dab7fe000)
>          /lib64/ld-linux-x86-64.so.2 (0x00007f9dacf44000)
>          libfreebl3.so => /lib64/libfreebl3.so (0x00007f9dab5fb000)
>
> but the pgbackrest need this perl path i thin -   libperl.so =>
> /usr/lib64/perl5/CORE/libperl.so (0x00007f955333b000)
>
>
> still we getting the error,
>
> ==> 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-10 19:23:39.525 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]:
> 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/0x103a528/pgBackRest/Db.pm line 10.
>          at /loader/0x103a528/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
>          Carp::croak('Can\'t load
> \'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
> /usr/lib64/perl5/DynaLoader.pm line 98
>          DynaLoader::croak('Can\'t load
> \'/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so\...') called at
> /usr/lib64/perl5/DynaLoader.pm line 190
>          DynaLoader::bootstrap('DBD::Pg', 'version=HASH(0x19b1a68)')
> called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73
>          require DBD/Pg.pm called at /loader/0x103a528/pgBackRest/Db.pm
> line 10
>          pgBackRest::Db::BEGIN() called at
> /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          require pgBackRest/Db.pm called at
> /loader/0x103a528/pgBackRest/Archive/Common.pm line 16
>          pgBackRest::Archive::Common::BEGIN() called at
> /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          require pgBackRest/Archive/Common.pm called at
> /loader/0x103a528/pgBackRest/Archive/Get/File.pm line 15
>          pgBackRest::Archive::Get::File::BEGIN() called at
> /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          require pgBackRest/Archive/Get/File.pm called at
> /loader/0x103a528/pgBackRest/Protocol/Remote/Minion.pm line 17
>          pgBackRest::Protocol::Remote::Minion::BEGIN() called at
> /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          eval {...} called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>          require pgBackRest/Protocol/Remote/Minion.pm called at
> /loader/0x103a528/pgBackRest/Main.pm line 118
>          eval {...} called at /loader/0x103a528/pgBackRest/Main.pm line 286
>          pgBackRest::Main::main('remote') called at (eval 269) line 1
>          eval '($iResult, $bErrorC, $strMessage) =
> pgBackRest::Main::main(\'remote\')
>         ;' called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0
>
>
> can you please help this we are struggling to solve the issue,
>
> Regards,
> Prakash.R
>
>
>
>
>
> On Thu, May 9, 2019 at 10:58 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote:
>      > Hi David,
>      >
>      > I did the installation for using postgresql 10.4 version edb
>     standard
>      > edition.so again need to run the yum command or please advise me .
>
>     I don't have time to go through the below, but some issues filed at
>     pgbackrest about using EDB installed database:
>
>     https://github.com/pgbackrest/pgbackrest/issues?q=is%3Aissue+edb+is%3Aclosed
>
>      >
>      >
>      > Regards,
>      > Prakash.R
>      >
>      > On Thu, May 9, 2019, 22:24 David Steele <david@pgmasters.net
>     <mailto:david@pgmasters.net>
>      > <mailto:david@pgmasters.net <mailto:david@pgmasters.net>>> wrote:
>      >
>      >     On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
>      >      > Hi Adrian,
>      >      >
>      >      > I don't know about that client libraries can you please
>     explain
>      >     or share
>      >      > me the command I will show you the output and we need the
>      >     solution for
>      >      > this pgbackrest issue .
>      >
>      >     yum install postgresql10
>      >
>      >     should do it, but I thought pqlib was installed with the
>     server as well.
>      >       Perhaps not.
>      >
>      >     --
>      >     -David
>      > david@pgmasters.net <mailto:david@pgmasters.net>
>     <mailto:david@pgmasters.net <mailto:david@pgmasters.net>>
>      >
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426


--
Adrian Klaver
adrian.klaver@aklaver.com