/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so
On Fri, May 17, 2019 at 3:47 AM Prakash Ramakrishnan <
prakash.ramakrishnan...@nielsen.com> wrote:
> Hi Team,
>
> We had an issue with restore please find the details,need some help
>
> 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
> postg...@sydcosausd001.enterprisenet.org:/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
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
>
