Re: perl issue

[email protected] (Clive Eisen) Mon, 10 Jun 2019 06:25:57 +0100
Newsgroups	perl.dbi.users
Message-ID	<[email protected]>
yum whatprovides */Pg.so

yeilds

perl-DBD-Pg


> On 9 Jun 2019, at 20:42, Jens Rehsack <[email protected]> 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 <[email protected] <mailto:[email protected]>>:
>> 
>> /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so
>> 
>> On Fri, May 17, 2019 at 3:47 AM Prakash Ramakrishnan <[email protected] <mailto:[email protected]>> 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
>> [email protected] <>:/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 - [email protected] <mailto:[email protected]>
signature.asc (application/pgp-signature, 235 B)