yum whatprovides */Pg.so yeilds
perl-DBD-Pg > On 9 Jun 2019, at 20:42, Jens Rehsack <rehs...@gmail.com> wrote: > > Where does the /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so come from (rpm > -q...) > >> Am 08.06.2019 um 03:17 schrieb Zhang Jun <gb2...@gmail.com >> <mailto:gb2...@gmail.com>>: >> >> /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 >> <mailto: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, >> >> pgBackRest version: >> pgBackRest 2.13 - General help >> >> PostgreSQL version: >> PostgreSQL 10.4 >> >> Operating system/version - CentOS Linux release 7.5.1804 (Core) >> >> Did you install pgBackRest from source or from a package? >> >> yes >> >> 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 >> >> 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 > > -- > Jens Rehsack - rehs...@gmail.com <mailto:rehs...@gmail.com>
signature.asc
Description: Message signed with OpenPGP