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