Re: perl path issue

Hi Adrian,

I tried below method also not working restore,

==> alias pgbackrest='export
LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:$LD_LIBRARY_PATH;pgbackrest'
postgres(at)sydcosausd001(dot)enterprisenet(dot)org:/usr/lib64/perl5
==> 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 20:08:55.618 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:
Password:
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/0x796528/pgBackRest/Db.pm line 10.
at /loader/0x796528/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(0x110aac8)') called
at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73
require DBD/Pg.pm called at /loader/0x796528/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/0x796528/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/0x796528/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/0x796528/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/0x796528/pgBackRest/Main.pm line 118
eval {...} called at /loader/0x796528/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
Compilation failed in require at /loader/0x796528/pgBackRest/Db.pm
line 10.
at /loader/0x796528/pgBackRest/Main.pm line 12.

On Fri, May 10, 2019 at 2:54 PM Prakash Ramakrishnan <
prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:

> Hi Adrian,
>
> Some perl path is not working here please find the below details,
>
> ==> 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 --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/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(dot)klaver(at)aklaver(dot)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(at)pgmasters(dot)net
>> > <mailto:david(at)pgmasters(dot)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(at)pgmasters(dot)net <mailto:david(at)pgmasters(dot)net>
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
>

--

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