perl path issue

classic Classic list List threaded Threaded
53 messages Options
123
Reply | Threaded
Open this post in threaded view
|

perl path issue

Prakash Ramakrishnan-2

Hi Team,

We having perl issue for while during restore operation for using pgbackrest backup tool can you please do the needful.

2019-05-08 18:42:09.415 P00   INFO: restore command begin 2.13: --db-include=A4_Copy --log-level-console=info --pg1-path=/Postgres/prakash_pgbackrest --process-max=2 --repo1-host=sydcosacpp001.enterprisenet.org --repo1-host-config=/etc/pgbackrest.conf --repo1-host-user=postgres --repo1-path=/pgBACKUP/A4_ sydcosacpp001  /backup/A4_ sydcosacpp001   --stanza=A4_s sydcosacpp001  1
2019-05-08 18:42:15.082 P00  ERROR: [124]: remote process on ' sydcosacpp001  .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/0x226a528/pgBackRest/Db.pm line 10.
                                                at /loader/0x226a528/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


==> cd /usr/lib64/perl5/
[hidden email]:/usr/lib64/perl5
==> ls
arybase.pm     bits             CORE           Fcntl.pm      _h2ph_pre.ph  lib.pm   NDBM_File.pm  perllocal.pod  stdarg.ph       syslimits.ph  Unicode
asm            B.pm             Devel          features.ph   Hash          linux    ODBM_File.pm  POSIX.pm       stdc-predef.ph  syslog.ph     vendor_perl
asm-generic    Config_git.pl    Digest         File          I18N          machine  Opcode.pm     POSIX.pod      stddef.ph       Text          wait.ph
attributes.pm  Config_heavy.pl  DynaLoader.pm  Filter        IO            Math     O.pm          re.pm          sys             Tie           xlocale.ph
auto           Config.pm        endian.ph      GDBM_File.pm  IO.pm         MIME     ops.pm        SDBM_File.pm   Sys             Time
B              Config.pod       Errno.pm       gnu           IPC           mro.pm   PerlIO        signal.ph      syscall.ph      time.ph



--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
>
> Hi Team,
>
> We having perl issue for while during restore operation for using
> pgbackrest backup tool can you please do the needful.

Looks to me like the Postgres client library libpq is not installed or
cannot be found on this machine.

You will need to verify using your package manager.

>
> 2019-05-08 18:42:09.415 P00   INFO: restore command begin 2.13:
> --db-include=A4_Copy --log-level-console=info
> --pg1-path=/Postgres/prakash_pgbackrest --process-max=2
> --repo1-host=sydcosacpp001.enterprisenet.org
> <http://sydcosacpp001.enterprisenet.org>
> --repo1-host-config=/etc/pgbackrest.conf --repo1-host-user=postgres
> --repo1-path=/pgBACKUP/A4_ sydcosacpp001  /backup/A4_
> sydcosacpp001   --stanza=A4_s sydcosacpp001  1
> 2019-05-08 18:42:15.082 P00  ERROR: [124]: remote process on '
> sydcosacpp001  .enterprisenet.org <http://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/0x226a528/pgBackRest/Db.pm line 10.
>                                                  at
> /loader/0x226a528/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
>
>
> ==> cd /usr/lib64/perl5/
> [hidden email]:/usr/lib64/perl5
> ==> ls
> arybase.pm <http://arybase.pm>     bits             CORE          
>   Fcntl.pm      _h2ph_pre.ph <http://h2ph_pre.ph> lib.pm
> <http://lib.pm>   NDBM_File.pm  perllocal.pod stdarg.ph
> <http://stdarg.ph> syslimits.ph <http://syslimits.ph>  Unicode
> asm            B.pm             Devel features.ph <http://features.ph>  
>   Hash          linux    ODBM_File.pm  POSIX.pm stdc-predef.ph
> <http://stdc-predef.ph> syslog.ph <http://syslog.ph>     vendor_perl
> asm-generic    Config_git.pl    Digest         File          I18N        
>    machine  Opcode.pm     POSIX.pod stddef.ph <http://stddef.ph>      
>   Text wait.ph <http://wait.ph>
> attributes.pm <http://attributes.pm>  Config_heavy.pl  DynaLoader.pm  
> Filter        IO            Math     O.pm re.pm <http://re.pm>          
> sys             Tie xlocale.ph <http://xlocale.ph>
> auto           Config.pm endian.ph <http://endian.ph>      GDBM_File.pm  
> IO.pm         MIME ops.pm <http://ops.pm>        SDBM_File.pm   Sys      
>         Time
> B              Config.pod       Errno.pm       gnu           IPC mro.pm
> <http://mro.pm>   PerlIO signal.ph <http://signal.ph> syscall.ph
> <http://syscall.ph> time.ph <http://time.ph>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
On 5/9/19 9:39 AM, Adrian Klaver wrote:
> On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
>>
>> We having perl issue for while during restore operation for using
>> pgbackrest backup tool can you please do the needful.
>
> Looks to me like the Postgres client library libpq is not installed or
> cannot be found on this machine.

If pgBackRest was built from source here's the complete dependency list
for RHEL7:

yum install perl perl-Time-HiRes perl-Digest-SHA perl-DBD-Pg perl-JSON-PP

Regards,
--
-David
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
Thanks, I'll check it out. 

David am trying to restore the backup in dev server please find the below details ,

[root@sydcosausd001 ~]# yum install perl perl-Time-HiRes perl-Digest-SHA perl-DBD-Pg perl-JSON-PP
Loaded plugins: fastestmirror, product-id, search-disabled-repos, subscription-manager
Determining fastest mirrors
pgdg10                                                                                                                                | 4.1 kB  00:00:00
pgdg11                                                                                                                                | 4.1 kB  00:00:00
pgdg94                                                                                                                                | 4.1 kB  00:00:00
pgdg95                                                                                                                                | 4.1 kB  00:00:00
pgdg96                                                                                                                                | 4.1 kB  00:00:00
tnc_CentOS-Katello-Client_CentOS-Katello-Client                                                                                       | 2.1 kB  00:00:00
tnc_CentOS_extras_x86_64                                                                                                              | 2.1 kB  00:00:00
tnc_CentOS_os_x86_64                                                                                                                  | 2.1 kB  00:00:00
tnc_CentOS_sclo_x86_64_rh                                                                                                             | 2.1 kB  00:00:00
tnc_CentOS_sclo_x86_64_sclo                                                                                                           | 2.1 kB  00:00:00
tnc_CentOS_updates_x86_64                                                                                                             | 2.1 kB  00:00:00
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                       | 2.1 kB  00:00:00
tnc_TNC_Nielsen_tnc_nielsen_rpms                                                                                                      | 2.1 kB  00:00:00
(1/23): pgdg94/7/x86_64/primary_db                                                                                                    | 236 kB  00:00:02
(2/23): pgdg10/7/x86_64/primary_db                                                                                                    | 204 kB  00:00:02
(3/23): pgdg11/7/x86_64/primary_db                                                                                                    | 166 kB  00:00:02
(4/23): pgdg96/7/x86_64/primary_db                                                                                                    | 225 kB  00:00:02
(5/23): pgdg95/7/x86_64/primary_db                                                                                                    | 227 kB  00:00:03
(6/23): tnc_CentOS-Katello-Client_CentOS-Katello-Client/updateinfo                                                                    |   93 B  00:00:02
(7/23): tnc_CentOS-Katello-Client_CentOS-Katello-Client/primary                                                                       | 4.6 kB  00:00:02
(8/23): tnc_CentOS_extras_x86_64/updateinfo                                                                                           |   93 B  00:00:02
(9/23): tnc_CentOS_extras_x86_64/primary                                                                                              | 127 kB  00:00:02
(10/23): tnc_CentOS_os_x86_64/updateinfo                                                                                              |   93 B  00:00:01
(11/23): tnc_CentOS_os_x86_64/group                                                                                                   | 573 kB  00:00:03
(12/23): tnc_CentOS_sclo_x86_64_sclo/updateinfo                                                                                       |   93 B  00:00:02
(13/23): tnc_CentOS_sclo_x86_64_rh/updateinfo                                                                                         |   93 B  00:00:02
(14/23): tnc_CentOS_sclo_x86_64_sclo/primary                                                                                          | 203 kB  00:00:02
(15/23): tnc_CentOS_os_x86_64/primary                                                                                                 | 3.9 MB  00:00:03
(16/23): tnc_CentOS_updates_x86_64/updateinfo                                                                                         |   93 B  00:00:01
(17/23): tnc_CentOS_sclo_x86_64_rh/primary                                                                                            | 2.6 MB  00:00:04
(18/23): tnc_CentOS_updates_x86_64/primary                                                                                            | 2.0 MB  00:00:04
(19/23): tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7/updateinfo                                   | 1.6 MB  00:00:03
(20/23): tnc_TNC_Nielsen_tnc_nielsen_rpms/updateinfo                                                                                  |   93 B  00:00:02
(21/23): tnc_TNC_Nielsen_tnc_nielsen_rpms/primary                                                                                     |  13 kB  00:00:02
(22/23): tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7/group                                        | 1.2 MB  00:00:07
(23/23): tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7/primary                                      |  14 MB  00:00:08
tnc_CentOS-Katello-Client_CentOS-Katello-Client                                                                                                        16/16
tnc_CentOS_extras_x86_64                                                                                                                             385/385
tnc_CentOS_os_x86_64                                                                                                                             10019/10019
tnc_CentOS_sclo_x86_64_rh                                                                                                                          8113/8113
tnc_CentOS_sclo_x86_64_sclo                                                                                                                          756/756
tnc_CentOS_updates_x86_64                                                                                                                          1511/1511
tnc_Extra_Packages_for_Enterprise_Linux_7_Extra_Packages_for_Enterprise_Linux_7                                                                  39852/39852
tnc_TNC_Nielsen_tnc_nielsen_rpms                                                                                                                       48/48
Package 4:perl-Time-HiRes-1.9725-3.el7.x86_64 already installed and latest version
Package 1:perl-Digest-SHA-5.85-4.el7.x86_64 already installed and latest version
Package perl-DBD-Pg-2.19.3-4.el7.x86_64 already installed and latest version
Package perl-JSON-PP-2.27202-2.el7.noarch already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package perl.x86_64 4:5.16.3-292.el7 will be updated
---> Package perl.x86_64 4:5.16.3-294.el7_6 will be an update
--> Processing Dependency: perl-libs = 4:5.16.3-294.el7_6 for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Running transaction check
---> Package perl-libs.x86_64 4:5.16.3-292.el7 will be updated
---> Package perl-libs.x86_64 4:5.16.3-294.el7_6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================
 Package                         Arch                         Version                                  Repository                                       Size
=============================================================================================================================================================
Updating:
 perl                            x86_64                       4:5.16.3-294.el7_6                       tnc_CentOS_updates_x86_64                       8.0 M
Updating for dependencies:
 perl-libs                       x86_64                       4:5.16.3-294.el7_6                       tnc_CentOS_updates_x86_64                       688 k

Transaction Summary
=============================================================================================================================================================
Upgrade  1 Package (+1 Dependent package)

Total download size: 8.6 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/2): perl-libs-5.16.3-294.el7_6.x86_64.rpm                                                                                          | 688 kB  00:00:03
(2/2): perl-5.16.3-294.el7_6.x86_64.rpm                                                                                               | 8.0 MB  00:00:06
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                        1.4 MB/s | 8.6 MB  00:00:06
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : 4:perl-libs-5.16.3-294.el7_6.x86_64                                                                                                       1/4
  Updating   : 4:perl-5.16.3-294.el7_6.x86_64                                                                                                            2/4
  Cleanup    : 4:perl-5.16.3-292.el7.x86_64                                                                                                              3/4
  Cleanup    : 4:perl-libs-5.16.3-292.el7.x86_64                                                                                                         4/4
  Verifying  : 4:perl-libs-5.16.3-294.el7_6.x86_64                                                                                                       1/4
  Verifying  : 4:perl-5.16.3-294.el7_6.x86_64                                                                                                            2/4
  Verifying  : 4:perl-5.16.3-292.el7.x86_64                                                                                                              3/4
  Verifying  : 4:perl-libs-5.16.3-292.el7.x86_64                                                                                                         4/4

Updated:
  perl.x86_64 4:5.16.3-294.el7_6

Dependency Updated:
  perl-libs.x86_64 4:5.16.3-294.el7_6

Complete!
[root@sydcosausd001 ~]# exit
logout
[hidden email]:/var/log/pgbackrest
==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres/prakash_pgbackrest --process-max=2 --db-include=A4_Copy restore --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001
2019-05-10 00:56:22.585 P00   INFO: restore command begin 2.13: --db-include=A4_Copy --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/0x172c528/pgBackRest/Db.pm line 10.
        at /loader/0x172c528/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(0x20a3a68)') called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73
        require DBD/Pg.pm called at /loader/0x172c528/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/0x172c528/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/0x172c528/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/0x172c528/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/0x172c528/pgBackRest/Main.pm line 118
        eval {...} called at /loader/0x172c528/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/0x172c528/pgBackRest/Db.pm line 10.
        at /loader/0x172c528/pgBackRest/Main.pm line 12.




source files:

Please find the below details,

  1. pgBackRest version:

pgBackRest 2.13 - General help

  1. PostgreSQL version:

PostgreSQL 10.4

  1. Operating system/version - CentOS Linux release 7.5.1804 (Core)

  2. Did you install pgBackRest from source or from a package?

yes

  1. Please attach the following as applicable:
    • pgbackrest.conf file(s)
      ==> cat /etc/pgbackrest.conf
      #[global]
      #repo1-path=/Postgres/pgBACKUP/A4_sydcosausd001
      #retention-diff=4
      #retention-full=4
      #retention-archive=2
      #start-fast=y
      #process-max=4
      #archive-async=y

#[global:archive-push]
#process-max=4

#[A4_sydcosausd001]
#db-path=/Postgres/pgDATA/data

[global]
repo1-host=sydcosafpp001.enterprisenet.org
repo1-host-user=postgres
repo1-host-config=/etc/pgbackrest.conf
repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001

[A4_sydcosafpp001]
pg1-path=/Postgres/prakash_pgbackrest

- `postgresql.conf` settings applicable to pgBackRest (`archive_command`, `archive_mode`, `listen_addresses`, `max_wal_senders`, `wal_level`, `port`)


postgres=# show port;

port

5432
(1 row)

postgres=# show archive_command ;
archive_command

export LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:${LD_LIBRARY_PATH};pgbackrest --stanza=A4_sydcosausd001 archive-push %p
(1 row)

postgres=# show archive_mode;
archive_mode

on
(1 row)

postgres=# show listen_addresses ;
listen_addresses

10.228.13.46
(1 row)

postgres=# show max_wal_senders ;
max_wal_senders

3
(1 row)

postgres=# show wal_level ;
wal_level

replica
(1 row)

- log file in `/var/log/pgbackrest` for the commands run (e.g. `/var/log/pgbackrest/mystanza_backup.log`)

==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres/prakash_pgbackrest --process-max=2 --db-include=A4_Copy restore --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001

2019-05-08 18:31:15.511 P00 INFO: restore command begin 2.13: --db-include=A4_Copy --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/0x23c3528/pgBackRest/Db.pm line 10.
at /loader/0x23c3528/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(0x2d3aa68)') called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73
require DBD/Pg.pm called at /loader/0x23c3528/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/0x23c3528/pgBackRest/Archive/Common.pm line 16
pgBackRest::Archive::Common::BEGIN() called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0

  1. Describe the issue:

Hi Team,

we have trying to do restore the backup from source is production and target is dev server and while during above pg_backrest restore command getting below error,
This is some high priority issue please do the needful and we have perl path and files and not able load the files,

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/0x23c3528/pgBackRest/Db.pm line 10.

   ==> pwd

/usr/lib64/perl5
[hidden email]:/usr/lib64/perl5
==> ls
arybase.pm bits CORE Fcntl.pm _h2ph_pre.ph lib.pm NDBM_File.pm perllocal.pod stdarg.ph syslimits.ph Unicode
asm B.pm Devel features.ph Hash linux ODBM_File.pm POSIX.pm stdc-predef.ph syslog.ph vendor_perl
asm-generic Config_git.pl Digest File I18N machine Opcode.pm POSIX.pod stddef.ph Text wait.ph
attributes.pm Config_heavy.pl DynaLoader.pm Filter IO Math O.pm re.pm sys Tie xlocale.ph
auto Config.pm endian.ph GDBM_File.pm IO.pm MIME ops.pm SDBM_File.pm Sys Time
B Config.pod Errno.pm gnu IPC mro.pm PerlIO signal.ph syscall.ph time.ph

more A4_sydcosafpp001-restore.log

2019-05-02 14:50:00.028 P00 INFO: restore command begin 2.10: --log-level-console=detail --pg1-path=/pgDATA/datanew --repo1-host=sydcosafpp001.enterprisene
t.org --repo1-host-config=/etc/pgbackrest.conf --repo1-host-user=postgres --repo1-path=/pgBACKUP/A4_sydcosafpp001 --stanza=A4_sydcosafpp001 --target="2019-05
-01 10:58:18.000000+01" --type=time
2019-05-02 14:50:07.930 P00 ERROR: [124]: remote process on 'sydcosafpp001.enterprisenet.org' terminated unexpectedly [124]: ERROR: [124]: process terminate
d 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/0x1623548/pgBackRest/Db.pm line 10.
at /loader/0x1623548/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/Dy
naLoader.pm line 98
DynaLoader::croak('Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') called at /usr/lib64/pe
rl5/DynaLoader.pm line 190
DynaLoader::bootstrap('DBD::Pg', 'version=HASH(0x1f9a938)') called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm
line 73





On Thu, May 9, 2019 at 8:17 PM David Steele <[hidden email]> wrote:
On 5/9/19 9:39 AM, Adrian Klaver wrote:
> On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
>>
>> We having perl issue for while during restore operation for using
>> pgbackrest backup tool can you please do the needful.
>
> Looks to me like the Postgres client library libpq is not installed or
> cannot be found on this machine.

If pgBackRest was built from source here's the complete dependency list
for RHEL7:

yum install perl perl-Time-HiRes perl-Digest-SHA perl-DBD-Pg perl-JSON-PP

Regards,
--
-David
[hidden email]


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote:
>
> David am trying to restore the backup in dev server please find the
> below details ,

libpq should be installed with Postgres.  Have you installed Postgres yet?

--
-David
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
Yes, I did. 

postgres 12546     1  0 Apr28 ?        00:03:07 /opt/app/PostgreSQL/10/bin/postgres
postgres 12554 12546  0 Apr28 ?        00:04:12 postgres: logger process
postgres 12557 12546  0 Apr28 ?        01:06:28 postgres: checkpointer process
postgres 12558 12546  0 Apr28 ?        00:01:57 postgres: writer process
postgres 12559 12546  0 Apr28 ?        01:47:41 postgres: wal writer process
postgres 12560 12546  0 Apr28 ?        00:02:05 postgres: autovacuum launcher process
postgres 12561 12546  0 Apr28 ?        00:26:30 postgres: archiver process   failed on 000000010000142700000032
postgres 12562 12546  0 Apr28 ?        00:13:20 postgres: stats collector process
postgres 12563 12546  0 Apr28 ?        00:00:02 postgres: bgworker: logical replication launcher
root     12858 28000  0 May09 ?        00:00:00 sshd: postgres [priv]
postgres 12896 12858  0 May09 ?        00:00:00 sshd: postgres@pts/0


On Thu, May 9, 2019 at 8:38 PM David Steele <[hidden email]> wrote:
On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote:
>
> David am trying to restore the backup in dev server please find the
> below details ,

libpq should be installed with Postgres.  Have you installed Postgres yet?

--
-David
[hidden email]


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
On 5/9/19 11:12 AM, Prakash Ramakrishnan wrote:
> Yes, I did. 

OK, then I would say something is wrong with your package configuration,
but I don't know what it might be.

Regards,
--
-David
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
In reply to this post by Prakash Ramakrishnan-2
On 5/9/19 8:12 AM, Prakash Ramakrishnan wrote:
> Yes, I did.

The server is there, but where the client libraries installed?

What does your package manager show for installed Postgres packages?

>
> postgres 12546     1  0 Apr28 ?        00:03:07
> /opt/app/PostgreSQL/10/bin/postgres
> postgres 12554 12546  0 Apr28 ?        00:04:12 postgres: logger process
> postgres 12557 12546  0 Apr28 ?        01:06:28 postgres: checkpointer
> process
> postgres 12558 12546  0 Apr28 ?        00:01:57 postgres: writer process
> postgres 12559 12546  0 Apr28 ?        01:47:41 postgres: wal writer process
> postgres 12560 12546  0 Apr28 ?        00:02:05 postgres: autovacuum
> launcher process
> postgres 12561 12546  0 Apr28 ?        00:26:30 postgres: archiver
> process   failed on 000000010000142700000032
> postgres 12562 12546  0 Apr28 ?        00:13:20 postgres: stats
> collector process
> postgres 12563 12546  0 Apr28 ?        00:00:02 postgres: bgworker:
> logical replication launcher
> root     12858 28000  0 May09 ?        00:00:00 sshd: postgres [priv]
> postgres 12896 12858  0 May09 ?        00:00:00 sshd: postgres@pts/0
>
>
> On Thu, May 9, 2019 at 8:38 PM David Steele <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote:
>      >
>      > David am trying to restore the backup in dev server please find the
>      > below details ,
>
>     libpq should be installed with Postgres.  Have you installed
>     Postgres yet?
>
>     --
>     -David
>     [hidden email] <mailto:[hidden email]>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
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 .



Regards,
Prakash.R

On Thu, May 9, 2019, 22:07 Adrian Klaver <[hidden email]> wrote:
On 5/9/19 8:12 AM, Prakash Ramakrishnan wrote:
> Yes, I did.

The server is there, but where the client libraries installed?

What does your package manager show for installed Postgres packages?

>
> postgres 12546     1  0 Apr28 ?        00:03:07
> /opt/app/PostgreSQL/10/bin/postgres
> postgres 12554 12546  0 Apr28 ?        00:04:12 postgres: logger process
> postgres 12557 12546  0 Apr28 ?        01:06:28 postgres: checkpointer
> process
> postgres 12558 12546  0 Apr28 ?        00:01:57 postgres: writer process
> postgres 12559 12546  0 Apr28 ?        01:47:41 postgres: wal writer process
> postgres 12560 12546  0 Apr28 ?        00:02:05 postgres: autovacuum
> launcher process
> postgres 12561 12546  0 Apr28 ?        00:26:30 postgres: archiver
> process   failed on 000000010000142700000032
> postgres 12562 12546  0 Apr28 ?        00:13:20 postgres: stats
> collector process
> postgres 12563 12546  0 Apr28 ?        00:00:02 postgres: bgworker:
> logical replication launcher
> root     12858 28000  0 May09 ?        00:00:00 sshd: postgres [priv]
> postgres 12896 12858  0 May09 ?        00:00:00 sshd: postgres@pts/0
>
>
> On Thu, May 9, 2019 at 8:38 PM David Steele <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote:
>      >
>      > David am trying to restore the backup in dev server please find the
>      > below details ,
>
>     libpq should be installed with Postgres.  Have you installed
>     Postgres yet?
>
>     --
>     -David
>     [hidden email] <mailto:[hidden email]>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426


--
Adrian Klaver
[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
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
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
On 5/9/19 9:54 AM, David Steele 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

Do you really want to do this as the server is already installed?

>
> should do it, but I thought pqlib was installed with the server as well.
>   Perhaps not.
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
In reply to this post by David Steele
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 .


Regards,
Prakash.R

On Thu, May 9, 2019, 22:24 David Steele <[hidden email]> 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
[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
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 .

So you are using the EDB installer correct?

If so YUM is not going to help you.

>
>
> Regards,
> Prakash.R
>
> On Thu, May 9, 2019, 22:24 David Steele <[hidden email]
> <mailto:[hidden email]>> 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
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
In reply to this post by Adrian Klaver-4
On 5/9/19 12:58 PM, Adrian Klaver wrote:

> On 5/9/19 9:54 AM, David Steele 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
>
> Do you really want to do this as the server is already installed?

Perhaps not, but I was hoping it might fix a broken package.  Since he's
running EDB it almost certainly won't help.

--
-David
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

David Steele
In reply to this post by Prakash Ramakrishnan-2
On 5/9/19 12:58 PM, Prakash Ramakrishnan wrote:
>
> 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 .

It really depends on how you've installed EDB, packages or their
customer installer.

The custom installer installs stuff in non-standard locations so likely
won't work without a lot of tweaking.  I don't have any experience with
the EDB packages.

Devrim?

--
-David
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
In reply to this post by Prakash Ramakrishnan-2
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 .

Should have added to previous post. A heads up:

Postgres 10.x is the last Linux version you can use the EDB installer.
Going forward you will need to use the native packages:

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

"Please Note: EDB no longer provides PostgreSQL installers for Linux,
and users are encouraged to use the platform-native packages. For more
information, please see this blog post on Platform Native EDB Packages
for Linux Users."

https://postgresrocks.enterprisedb.com/t5/Postgres-Gems/Platform-Native-EDB-Packages-for-Linux-Users/ba-p/2362?_ga=2.116418510.996235935.1557421212-1173178781.1557421212

>
>
> Regards,
> Prakash.R
>
> On Thu, May 9, 2019, 22:24 David Steele <[hidden email]
> <mailto:[hidden email]>> 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
"Please Note: EDB no longer provides PostgreSQL installers for Linux,
and users are encouraged to use the platform-native packages. For more
information, please see this blog post on Platform Native EDB Packages
for Linux Users.
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
In reply to this post by Prakash Ramakrishnan-2
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 <[hidden email]
> <mailto:[hidden email]>> 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
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
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 <[hidden email]> 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 <[hidden email]
> <mailto:[hidden email]>> 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
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


--



Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Prakash Ramakrishnan-2
Hi Adrian,

I tried below method also not working restore,

==> alias pgbackrest='export LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:$LD_LIBRARY_PATH;pgbackrest'
[hidden email]:/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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]
> <mailto:[hidden email]>> 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
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


--



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
Reply | Threaded
Open this post in threaded view
|

Re: perl path issue

Adrian Klaver-4
In reply to this post by Prakash Ramakrishnan-2
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 <[hidden email]
> <mailto:[hidden email]>> 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 <[hidden email]
>     <mailto:[hidden email]>
>      > <mailto:[hidden email] <mailto:[hidden email]>>> 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
>      > [hidden email] <mailto:[hidden email]>
>     <mailto:[hidden email] <mailto:[hidden email]>>
>      >
>
>
>     --
>     Adrian Klaver
>     [hidden email] <mailto:[hidden email]>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426


--
Adrian Klaver
[hidden email]


123