Search Postgresql Archives

Re: perl path issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:/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.ramakrishnan.ap@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
> <mailto:david@xxxxxxxxxxxxx>> 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@xxxxxxxxxxxxx <mailto:david@xxxxxxxxxxxxx>
>


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--



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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux