PERL ISSUE
Prakash Ramakrishnan <[email protected]> Mon, 13 May 2019 20:27:37 +0530
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <CAA2eZXz5GFE6bcBNudMtSx1BJLTruYdwn6aGt+u=bHn8oLf3=g@mail.gmail.com> |
--000000000000c67bae0588c6239b
Content-Type: text/plain; charset="UTF-8"
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
[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
--
--000000000000c67bae0588c6239b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Hi Team,<div><br></div><div><div>We had an issue with rest=
ore please find the details,need some help</div><div><br></div><div><p styl=
e=3D"box-sizing:border-box;margin-bottom:16px;color:rgb(36,41,46);font-fami=
ly:-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sa=
ns-serif,"Apple Color Emoji","Segoe UI Emoji","Seg=
oe UI Symbol";font-size:14px;margin-top:0px">Please find the below det=
ails,</p><ol style=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0=
px;padding-left:2em;color:rgb(36,41,46);font-family:-apple-system,BlinkMacS=
ystemFont,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color=
Emoji","Segoe UI Emoji","Segoe UI Symbol";font-si=
ze:14px"><li style=3D"margin-left:0px;box-sizing:border-box">pgBackRest ver=
sion:</li></ol><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-=
top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,&q=
uot;Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji"=
,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px">pgB=
ackRest 2.13 - General help</p><ol start=3D"2" style=3D"box-sizing:border-b=
ox;margin-bottom:16px;margin-top:0px;padding-left:2em;color:rgb(36,41,46);f=
ont-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,=
Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji",&=
quot;Segoe UI Symbol";font-size:14px"><li style=3D"margin-left:0px;box=
-sizing:border-box">PostgreSQL version:</li></ol><p style=3D"box-sizing:bor=
der-box;margin-bottom:16px;margin-top:0px;color:rgb(36,41,46);font-family:-=
apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-s=
erif,"Apple Color Emoji","Segoe UI Emoji","Segoe U=
I Symbol";font-size:14px">PostgreSQL 10.4</p><ol start=3D"3" style=3D"=
box-sizing:border-box;margin-bottom:16px;margin-top:0px;padding-left:2em;co=
lor:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe =
UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","Seg=
oe UI Emoji","Segoe UI Symbol";font-size:14px"><li style=3D"=
margin-left:0px;box-sizing:border-box"><p style=3D"box-sizing:border-box;ma=
rgin-bottom:16px;margin-top:0px">Operating system/version - CentOS Linux re=
lease 7.5.1804 (Core)</p></li><li style=3D"margin-left:0px;box-sizing:borde=
r-box;margin-top:0.25em"><p style=3D"box-sizing:border-box;margin-bottom:16=
px;margin-top:0px">Did you install pgBackRest from source or from a package=
?</p></li></ol><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-=
top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,&q=
uot;Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji"=
,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px">yes=
</p><ol start=3D"5" style=3D"box-sizing:border-box;margin-bottom:16px;margi=
n-top:0px;padding-left:2em;color:rgb(36,41,46);font-family:-apple-system,Bl=
inkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-serif,"Appl=
e Color Emoji","Segoe UI Emoji","Segoe UI Symbol";=
font-size:14px"><li style=3D"margin-left:0px;box-sizing:border-box">Please =
attach the following as applicable:<ul style=3D"box-sizing:border-box;margi=
n-bottom:0px;margin-top:0px;padding-left:2em"><li style=3D"margin-left:0px;=
box-sizing:border-box"><code style=3D"box-sizing:border-box;font-family:SFM=
ono-Regular,Consolas,"Liberation Mono",Menlo,Courier,monospace;fo=
nt-size:11.9px;background-color:rgba(27,31,35,0.05);border-radius:3px;margi=
n:0px;padding:0.2em 0.4em">pgbackrest.conf</code>=C2=A0file(s)<br style=3D"=
box-sizing:border-box">=3D=3D> cat /etc/pgbackrest.conf<br style=3D"box-=
sizing:border-box">#[global]<br style=3D"box-sizing:border-box">#repo1-path=
=3D/Postgres/pgBACKUP/A4_sydcosausd001<br style=3D"box-sizing:border-box">#=
retention-diff=3D4<br style=3D"box-sizing:border-box">#retention-full=3D4<b=
r style=3D"box-sizing:border-box">#retention-archive=3D2<br style=3D"box-si=
zing:border-box">#start-fast=3Dy<br style=3D"box-sizing:border-box">#proces=
s-max=3D4<br style=3D"box-sizing:border-box">#archive-async=3Dy</li></ul></=
li></ol><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px=
;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,"Seg=
oe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji","=
Segoe UI Emoji","Segoe UI Symbol";font-size:14px">#[global:a=
rchive-push]<br style=3D"box-sizing:border-box">#process-max=3D4</p><p styl=
e=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px;color:rgb(36,4=
1,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Hel=
vetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji&=
quot;,"Segoe UI Symbol";font-size:14px">#[A4_sydcosausd001]<br st=
yle=3D"box-sizing:border-box">#db-path=3D/Postgres/pgDATA/data</p><p style=
=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px;color:rgb(36,41=
,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Helv=
etica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji&q=
uot;,"Segoe UI Symbol";font-size:14px">[global]<br style=3D"box-s=
izing:border-box">repo1-host=3D<a href=3D"http://sydcosafpp001.enterprisene=
t.org/" target=3D"_blank">sydcosafpp001.enterprisenet.org</a><br style=3D"b=
ox-sizing:border-box">repo1-host-user=3Dpostgres<br style=3D"box-sizing:bor=
der-box">repo1-host-config=3D/etc/pgbackrest.conf<br style=3D"box-sizing:bo=
rder-box">repo1-path=3D/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001</=
p><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px;color=
:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI&=
quot;,Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe =
UI Emoji","Segoe UI Symbol";font-size:14px">[A4_sydcosafpp00=
1]<br style=3D"box-sizing:border-box">pg1-path=3D/Postgres/prakash_pgbackre=
st</p><pre style=3D"white-space:pre-wrap;box-sizing:border-box;font-family:=
SFMono-Regular,Consolas,"Liberation Mono",Menlo,Courier,monospace=
;font-size:11.9px;margin-bottom:16px;margin-top:0px;background-color:rgb(24=
6,248,250);border-radius:3px;line-height:1.45;overflow:auto;padding:16px;co=
lor:rgb(36,41,46)"><code style=3D"box-sizing:border-box;font-family:SFMono-=
Regular,Consolas,"Liberation Mono",Menlo,Courier,monospace;font-s=
ize:11.9px;background:transparent;border-radius:3px;margin:0px;padding:0px;=
border:0px;word-break:normal;display:inline;line-height:inherit;overflow:vi=
sible">- `postgresql.conf` settings applicable to pgBackRest (`archive_comm=
and`, `archive_mode`, `listen_addresses`, `max_wal_senders`, `wal_level`, `=
port`)
postgres=3D# show port;
</code></pre><h2 style=3D"box-sizing:border-box;margin-bottom:16px;margin-t=
op:24px;line-height:1.25;border-bottom:1px solid rgb(234,236,239);padding-b=
ottom:0.3em;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFon=
t,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji&q=
uot;,"Segoe UI Emoji","Segoe UI Symbol"">port</h2><p st=
yle=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px;color:rgb(36=
,41,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",H=
elvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoj=
i","Segoe UI Symbol";font-size:14px">5432<br style=3D"box-si=
zing:border-box">(1 row)</p><h2 style=3D"box-sizing:border-box;margin-botto=
m:16px;margin-top:24px;line-height:1.25;border-bottom:1px solid rgb(234,236=
,239);padding-bottom:0.3em;color:rgb(36,41,46);font-family:-apple-system,Bl=
inkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-serif,"Appl=
e Color Emoji","Segoe UI Emoji","Segoe UI Symbol""=
>postgres=3D# show archive_command ;<br style=3D"box-sizing:border-box">arc=
hive_command</h2><p style=3D"box-sizing:border-box;margin-bottom:16px;margi=
n-top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,=
"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji&quo=
t;,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px">e=
xport LD_LIBRARY_PATH=3D/usr/lib64/perl5/CORE:${LD_LIBRARY_PATH};pgbackrest=
--stanza=3DA4_sydcosausd001 archive-push %p<br style=3D"box-sizing:border-=
box">(1 row)</p><h2 style=3D"box-sizing:border-box;margin-bottom:16px;margi=
n-top:24px;line-height:1.25;border-bottom:1px solid rgb(234,236,239);paddin=
g-bottom:0.3em;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystem=
Font,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoj=
i","Segoe UI Emoji","Segoe UI Symbol"">postgres=3D=
# show archive_mode;<br style=3D"box-sizing:border-box">archive_mode</h2><p=
style=3D"box-sizing:border-box;margin-bottom:16px;margin-top:0px;color:rgb=
(36,41,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI"=
;,Helvetica,Arial,sans-serif,"Apple Color Emoji","Segoe UI E=
moji","Segoe UI Symbol";font-size:14px">on<br style=3D"box-s=
izing:border-box">(1 row)</p><h2 style=3D"box-sizing:border-box;margin-bott=
om:16px;margin-top:24px;line-height:1.25;border-bottom:1px solid rgb(234,23=
6,239);padding-bottom:0.3em;color:rgb(36,41,46);font-family:-apple-system,B=
linkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-serif,"App=
le Color Emoji","Segoe UI Emoji","Segoe UI Symbol"=
">postgres=3D# show listen_addresses ;<br style=3D"box-sizing:border-box">l=
isten_addresses</h2><p style=3D"box-sizing:border-box;margin-bottom:16px;ma=
rgin-top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFo=
nt,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji&=
quot;,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px=
">10.228.13.46<br style=3D"box-sizing:border-box">(1 row)</p><h2 style=3D"b=
ox-sizing:border-box;margin-bottom:16px;margin-top:24px;line-height:1.25;bo=
rder-bottom:1px solid rgb(234,236,239);padding-bottom:0.3em;color:rgb(36,41=
,46);font-family:-apple-system,BlinkMacSystemFont,"Segoe UI",Helv=
etica,Arial,sans-serif,"Apple Color Emoji","Segoe UI Emoji&q=
uot;,"Segoe UI Symbol"">postgres=3D# show max_wal_senders ;<br st=
yle=3D"box-sizing:border-box">max_wal_senders</h2><p style=3D"box-sizing:bo=
rder-box;margin-bottom:16px;margin-top:0px;color:rgb(36,41,46);font-family:=
-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-=
serif,"Apple Color Emoji","Segoe UI Emoji","Segoe =
UI Symbol";font-size:14px">3<br style=3D"box-sizing:border-box">(1 row=
)</p><h2 style=3D"box-sizing:border-box;margin-bottom:16px;margin-top:24px;=
line-height:1.25;border-bottom:1px solid rgb(234,236,239);padding-bottom:0.=
3em;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,"=
Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji",&qu=
ot;Segoe UI Emoji","Segoe UI Symbol"">postgres=3D# show wal_=
level ;<br style=3D"box-sizing:border-box">wal_level</h2><p style=3D"box-si=
zing:border-box;margin-bottom:16px;margin-top:0px;color:rgb(36,41,46);font-=
family:-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Aria=
l,sans-serif,"Apple Color Emoji","Segoe UI Emoji","=
;Segoe UI Symbol";font-size:14px">replica<br style=3D"box-sizing:borde=
r-box">(1 row)</p><pre style=3D"white-space:pre-wrap;box-sizing:border-box;=
font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,Couri=
er,monospace;font-size:11.9px;margin-bottom:16px;margin-top:0px;background-=
color:rgb(246,248,250);border-radius:3px;line-height:1.45;overflow:auto;pad=
ding:16px;color:rgb(36,41,46)"><code style=3D"box-sizing:border-box;font-fa=
mily:SFMono-Regular,Consolas,"Liberation Mono",Menlo,Courier,mono=
space;font-size:11.9px;background:transparent;border-radius:3px;margin:0px;=
padding:0px;border:0px;word-break:normal;display:inline;line-height:inherit=
;overflow:visible">- log file in `/var/log/pgbackrest` for the commands run=
(e.g. `/var/log/pgbackrest/mystanza_backup.log`)
=3D=3D> pgbackrest --stanza=3DA4_sydcosafpp001 --log-level-console=3Dinf=
o --db-path=3D/Postgres/prakash_pgbackrest --process-max=3D2 --db-include=
=3DA4_Copy restore --repo1-path=3D/pgBACKUP/A4_sydcosafpp001/backup/A4_sydc=
osafpp001
</code></pre><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-to=
p:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,&quo=
t;Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji",&=
quot;Segoe UI Emoji","Segoe UI Symbol";font-size:14px">2019-=
05-08 18:31:15.511 P00 INFO: restore command begin 2.13: --db-include=3DA4_=
Copy --log-level-console=3Dinfo --pg1-path=3D/Postgres/prakash_pgbackrest -=
-process-max=3D2 --repo1-host=3D<a href=3D"http://sydcosafpp001.enterprisen=
et.org/" target=3D"_blank">sydcosafpp001.enterprisenet.org</a>=C2=A0--repo1=
-host-config=3D/etc/pgbackrest.conf --repo1-host-user=3Dpostgres --repo1-pa=
th=3D/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001 --stanza=3DA4_sydco=
safpp001<br style=3D"box-sizing:border-box">Password:<br style=3D"box-sizin=
g:border-box">ERROR [124]: : remote process on '<a href=3D"http://sydco=
safpp001.enterprisenet.org/" target=3D"_blank">sydcosafpp001.enterprisenet.=
org</a>' terminated unexpectedly [124]: ERROR: [124]: process terminate=
d due to an unhandled exception:<br style=3D"box-sizing:border-box">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 direc=
tory at /usr/lib64/perl5/DynaLoader.pm line 190.<br style=3D"box-sizing:bor=
der-box">at /loader/0x23c3528/pgBackRest/Db.pm line 10.<br style=3D"box-siz=
ing:border-box">at /loader/0x23c3528/pgBackRest/Main.pm line 12.<br style=
=3D"box-sizing:border-box">pgBackRest::Main::<span style=3D"box-sizing:bord=
er-box;font-weight:600">ANON</span>('Can't load '/usr/lib64/per=
l5/vendor_perl/auto/DBD/Pg/Pg.so...') called at /usr/share/perl5/vendor=
_perl/Carp.pm line 100<br style=3D"box-sizing:border-box">Carp::croak('=
Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...')=
called at /usr/lib64/perl5/DynaLoader.pm line 98<br style=3D"box-sizing:bo=
rder-box">DynaLoader::croak('Can't load '/usr/lib64/perl5/vendo=
r_perl/auto/DBD/Pg/Pg.so...') called at /usr/lib64/perl5/DynaLoader.pm =
line 190<br style=3D"box-sizing:border-box">DynaLoader::bootstrap('DBD:=
:Pg', 'version=3DHASH(0x2d3aa68)') called at /usr/lib64/perl5/v=
endor_perl/DBD/Pg.pm line 73<br style=3D"box-sizing:border-box">require DBD=
/Pg.pm called at /loader/0x23c3528/pgBackRest/Db.pm line 10<br style=3D"box=
-sizing:border-box">pgBackRest::Db::BEGIN() called at /usr/lib64/perl5/vend=
or_perl/DBD/Pg.pm line 0<br style=3D"box-sizing:border-box">eval {...} call=
ed at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0<br style=3D"box-sizing:=
border-box">require pgBackRest/Db.pm called at /loader/0x23c3528/pgBackRest=
/Archive/Common.pm line 16<br style=3D"box-sizing:border-box">pgBackRest::A=
rchive::Common::BEGIN() called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm li=
ne 0</p><ol start=3D"7" style=3D"box-sizing:border-box;margin-bottom:16px;m=
argin-top:0px;padding-left:2em;color:rgb(36,41,46);font-family:-apple-syste=
m,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-serif,"=
Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol&qu=
ot;;font-size:14px"><li style=3D"margin-left:0px;box-sizing:border-box">Des=
cribe the issue:</li></ol><p style=3D"box-sizing:border-box;margin-bottom:1=
6px;margin-top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSy=
stemFont,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color =
Emoji","Segoe UI Emoji","Segoe UI Symbol";font-siz=
e:14px">Hi Team,</p><p style=3D"box-sizing:border-box;margin-bottom:16px;ma=
rgin-top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFo=
nt,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji&=
quot;,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px=
">we have trying to do restore the backup from source is production and tar=
get is dev server and while during above pg_backrest restore command gettin=
g below error,<br style=3D"box-sizing:border-box">This is some high priorit=
y issue please do the needful and we have perl path and files and not able =
load the files,</p><p style=3D"box-sizing:border-box;margin-bottom:16px;mar=
gin-top:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFon=
t,"Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji&q=
uot;,"Segoe UI Emoji","Segoe UI Symbol";font-size:14px"=
>ERROR [124]: : remote process on '<a href=3D"http://sydcosafpp001.ente=
rprisenet.org/" target=3D"_blank">sydcosafpp001.enterprisenet.org</a>' =
terminated unexpectedly [124]: ERROR: [124]: process terminated due to an u=
nhandled exception:<br style=3D"box-sizing:border-box">Can't load '=
/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so' for module DBD::Pg: lib=
pq.so.5: cannot open shared object file: No such file or directory at /usr/=
lib64/perl5/DynaLoader.pm line 190.<br style=3D"box-sizing:border-box">at /=
loader/0x23c3528/pgBackRest/Db.pm line 10.</p><pre style=3D"white-space:pre=
-wrap;box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liber=
ation Mono",Menlo,Courier,monospace;font-size:11.9px;margin-bottom:16p=
x;margin-top:0px;background-color:rgb(246,248,250);border-radius:3px;line-h=
eight:1.45;overflow:auto;padding:16px;color:rgb(36,41,46)"><code style=3D"b=
ox-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation M=
ono",Menlo,Courier,monospace;font-size:11.9px;background:transparent;b=
order-radius:3px;margin:0px;padding:0px;border:0px;word-break:normal;displa=
y:inline;line-height:inherit;overflow:visible"> =3D=3D> pwd
</code></pre><p style=3D"box-sizing:border-box;margin-bottom:16px;margin-to=
p:0px;color:rgb(36,41,46);font-family:-apple-system,BlinkMacSystemFont,&quo=
t;Segoe UI",Helvetica,Arial,sans-serif,"Apple Color Emoji",&=
quot;Segoe UI Emoji","Segoe UI Symbol";font-size:14px">/usr/=
lib64/perl5<br style=3D"box-sizing:border-box"><a href=3D"mailto:postgres@s=
ydcosausd001.enterprisenet.org" target=3D"_blank" style=3D"color:rgb(3,102,=
214);box-sizing:border-box;background-color:transparent;text-decoration-lin=
e:none">[email protected]</a>:/usr/lib64/perl5<br st=
yle=3D"box-sizing:border-box">=3D=3D> ls<br style=3D"box-sizing:border-b=
ox"><a href=3D"http://arybase.pm/" target=3D"_blank">arybase.pm</a>=C2=A0bi=
ts CORE Fcntl.pm _<a href=3D"http://h2ph_pre.ph/" target=3D"_blank">h2ph_pr=
e.ph</a>=C2=A0<a href=3D"http://lib.pm/" target=3D"_blank">lib.pm</a>=C2=A0=
NDBM_File.pm perllocal.pod=C2=A0<a href=3D"http://stdarg.ph/" target=3D"_bl=
ank">stdarg.ph</a>=C2=A0<a href=3D"http://syslimits.ph/" target=3D"_blank">=
syslimits.ph</a>=C2=A0Unicode<br style=3D"box-sizing:border-box">asm B.pm D=
evel=C2=A0<a href=3D"http://features.ph/" target=3D"_blank">features.ph</a>=
=C2=A0Hash linux ODBM_File.pm POSIX.pm=C2=A0<a href=3D"http://stdc-predef.p=
h/" target=3D"_blank">stdc-predef.ph</a>=C2=A0<a href=3D"http://syslog.ph/"=
target=3D"_blank">syslog.ph</a>=C2=A0vendor_perl<br style=3D"box-sizing:bo=
rder-box">asm-generic Config_git.pl Digest File I18N machine Opcode.pm POSI=
X.pod=C2=A0<a href=3D"http://stddef.ph/" target=3D"_blank">stddef.ph</a>=C2=
=A0Text=C2=A0<a href=3D"http://wait.ph/" target=3D"_blank">wait.ph</a><br s=
tyle=3D"box-sizing:border-box"><a href=3D"http://attributes.pm/" target=3D"=
_blank">attributes.pm</a>=C2=A0Config_heavy.pl DynaLoader.pm Filter IO Math=
O.pm=C2=A0<a href=3D"http://re.pm/" target=3D"_blank">re.pm</a>=C2=A0sys T=
ie=C2=A0<a href=3D"http://xlocale.ph/" target=3D"_blank">xlocale.ph</a><br =
style=3D"box-sizing:border-box">auto Config.pm=C2=A0<a href=3D"http://endia=
n.ph/" target=3D"_blank">endian.ph</a>=C2=A0GDBM_File.pm IO.pm MIME=C2=A0<a=
href=3D"http://ops.pm/" target=3D"_blank">ops.pm</a>=C2=A0SDBM_File.pm Sys=
Time<br style=3D"box-sizing:border-box">B Config.pod Errno.pm gnu IPC=C2=
=A0<a href=3D"http://mro.pm/" target=3D"_blank">mro.pm</a>=C2=A0PerlIO=C2=
=A0<a href=3D"http://signal.ph/" target=3D"_blank">signal.ph</a>=C2=A0<a hr=
ef=3D"http://syscall.ph/" target=3D"_blank">syscall.ph</a>=C2=A0<a href=3D"=
http://time.ph/" target=3D"_blank">time.ph</a></p><p style=3D"box-sizing:bo=
rder-box;margin-bottom:16px;margin-top:0px;color:rgb(36,41,46);font-family:=
-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-=
serif,"Apple Color Emoji","Segoe UI Emoji","Segoe =
UI Symbol";font-size:14px">more A4_sydcosafpp001-restore.log</p><p sty=
le=3D"box-sizing:border-box;margin-top:0px;color:rgb(36,41,46);font-family:=
-apple-system,BlinkMacSystemFont,"Segoe UI",Helvetica,Arial,sans-=
serif,"Apple Color Emoji","Segoe UI Emoji","Segoe =
UI Symbol";font-size:14px;margin-bottom:0px">2019-05-02 14:50:00.028 P=
00 INFO: restore command begin 2.10: --log-level-console=3Ddetail --pg1-pat=
h=3D/pgDATA/datanew --repo1-host=3Dsydcosafpp001.enterprisene<br style=3D"b=
ox-sizing:border-box"><a href=3D"http://t.org/" target=3D"_blank">t.org</a>=
=C2=A0--repo1-host-config=3D/etc/pgbackrest.conf --repo1-host-user=3Dpostgr=
es --repo1-path=3D/pgBACKUP/A4_sydcosafpp001 --stanza=3DA4_sydcosafpp001 --=
target=3D"2019-05<br style=3D"box-sizing:border-box">-01 10:58:18.0000=
00+01" --type=3Dtime<br style=3D"box-sizing:border-box">2019-05-02 14:=
50:07.930 P00 ERROR: [124]: remote process on '<a href=3D"http://sydcos=
afpp001.enterprisenet.org/" target=3D"_blank">sydcosafpp001.enterprisenet.o=
rg</a>' terminated unexpectedly [124]: ERROR: [124]: process terminate<=
br style=3D"box-sizing:border-box">d due to an unhandled exception:<br styl=
e=3D"box-sizing:border-box">Can't load '/usr/lib64/perl5/vendor_per=
l/auto/DBD/Pg/Pg.so' for module DBD::Pg: libpq.so.5: cannot open shared=
<br style=3D"box-sizing:border-box">object file: No such file or directory =
at /usr/lib64/perl5/DynaLoader.pm line 190.<br style=3D"box-sizing:border-b=
ox">at /loader/0x1623548/pgBackRest/Db.pm line 10.<br style=3D"box-sizing:b=
order-box">at /loader/0x1623548/pgBackRest/Main.pm line 12.<br style=3D"box=
-sizing:border-box">pgBackRest::Main::<span style=3D"box-sizing:border-box;=
font-weight:600">ANON</span>('Can't load '/usr/lib64/perl5/vend=
or_perl/auto/DBD/Pg/Pg.so...') called at /usr<br style=3D"box-sizing:bo=
rder-box">/share/perl5/vendor_perl/Carp.pm line 100<br style=3D"box-sizing:=
border-box">Carp::croak('Can't load '/usr/lib64/perl5/vendor_pe=
rl/auto/DBD/Pg/Pg.so...') called at /usr/lib64/perl5/Dy<br style=3D"box=
-sizing:border-box">naLoader.pm line 98<br style=3D"box-sizing:border-box">=
DynaLoader::croak('Can't load '/usr/lib64/perl5/vendor_perl/aut=
o/DBD/Pg/Pg.so...') called at /usr/lib64/pe<br style=3D"box-sizing:bord=
er-box">rl5/DynaLoader.pm line 190<br style=3D"box-sizing:border-box">DynaL=
oader::bootstrap('DBD::Pg', 'version=3DHASH(0x1f9a938)') ca=
lled at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm<br style=3D"box-sizing:borde=
r-box">line 73</p></div></div><div><br></div>-- <br><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv dir=3D"ltr"><div dir=3D"ltr"><br><div><br></div><div><div><br></div><div=
><br></div></div></div></div></div></div></div>
--000000000000c67bae0588c6239b--