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>: > > /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
signature.asc
Description: Message signed with OpenPGP
