Hi Adrian, I did the installation for like ,
postgresql-10.4-1-linux-x64.run file. pgbackrest - yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rp <https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm> m yum install pgbackrest now what is the problem means we have to trying restore the backup prod to dev server. same setup for both servers. ==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres/prakash_pgbackrest --delta --process-max=2 --db-include=A4_Copy restore --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001 2019-05-10 22:46:20.813 P00 INFO: restore command begin 2.13: --db-include=A4_Copy --delta --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 Segmentation fault [email protected]: /opt/rh/rh-perl526/root/usr/lib64/perl5/CORE ==> alias pgbackrest='export LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:$LD_LIBRARY_PATH;pgbackrest' [email protected]: /opt/rh/rh-perl526/root/usr/lib64/perl5/CORE ==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres/prakash_pgbackrest --delta --process-max=2 --db-include=A4_Copy restore --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001 2019-05-10 22:46:36.197 P00 INFO: restore command begin 2.13: --db-include=A4_Copy --delta --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/0x2616528/pgBackRest/Db.pm line 10. at /loader/0x2616528/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 ==> locate Pg.so */usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so* /usr/local/lib64/perl5/auto/DBD/Pg/Pg.so On Fri, May 10, 2019 at 7:54 PM Adrian Klaver <[email protected]> wrote: > On 5/10/19 2:24 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Some perl path is not working here please find the below details, > > How did you install/build pgbackrest? > > The basic issue as I see it is that pgBackRest and your EDB Postgres are > living in separate worlds as far as each is concerned. To fix this you > have two options as I see it: > > 1) To reconcile then you will need to either consult the pgBackRest or > EDB folks for a solution, as I use neither and don't know how to make > then play well together. > > 2) Convert your Postgres server from using the EDB installer to using > the native packages. This is going to have to happen anyway going > forward off version 10. I would probably stick to the community packages > here: > > https://www.postgresql.org/download/linux/redhat/ > > > > > > ==> ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so > > linux-vdso.so.1 => (0x00007ffccf4a3000) > > * libperl.so => > > /opt/edb/languagepack-10/Perl-5.24/lib/CORE/libperl.so > (0x00007f9dac941000)* > > libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9dac725000) > > libc.so.6 => /lib64/libc.so.6 (0x00007f9dac358000) > > libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9dac13e000) > > libdl.so.2 => /lib64/libdl.so.2 (0x00007f9dabf3a000) > > libm.so.6 => /lib64/libm.so.6 (0x00007f9dabc38000) > > libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f9daba01000) > > libutil.so.1 => /lib64/libutil.so.1 (0x00007f9dab7fe000) > > /lib64/ld-linux-x86-64.so.2 (0x00007f9dacf44000) > > libfreebl3.so => /lib64/libfreebl3.so (0x00007f9dab5fb000) > > > > but the pgbackrest need this perl path i thin - libperl.so => > > /usr/lib64/perl5/CORE/libperl.so (0x00007f955333b000) > > > > > > still we getting the error, > > > > ==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info > > --db-path=/Postgres/prakash_pgbackrest --delta --process-max=2 > > --db-include=A4_Copy restore > > --repo1-path=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001 > > 2019-05-10 19:23:39.525 P00 INFO: restore command begin 2.13: > > --db-include=A4_Copy --delta --log-level-console=info > > --pg1-path=/Postgres/prakash_pgbackrest --process-max=2 > > --repo1-host=sydcosafpp001.enterprisenet.org > > <http://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 > > <http://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/0x103a528/pgBackRest/Db.pm line 10. > > at /loader/0x103a528/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(0x19b1a68)') > > called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 73 > > require DBD/Pg.pm called at /loader/0x103a528/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/0x103a528/pgBackRest/Archive/Common.pm line 16 > > pgBackRest::Archive::Common::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/Archive/Common.pm called at > > /loader/0x103a528/pgBackRest/Archive/Get/File.pm line 15 > > pgBackRest::Archive::Get::File::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/Archive/Get/File.pm called at > > /loader/0x103a528/pgBackRest/Protocol/Remote/Minion.pm line 17 > > pgBackRest::Protocol::Remote::Minion::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/Protocol/Remote/Minion.pm called at > > /loader/0x103a528/pgBackRest/Main.pm line 118 > > eval {...} called at /loader/0x103a528/pgBackRest/Main.pm line > 286 > > pgBackRest::Main::main('remote') called at (eval 269) line 1 > > eval '($iResult, $bErrorC, $strMessage) = > > pgBackRest::Main::main(\'remote\') > > ;' called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0 > > > > > > can you please help this we are struggling to solve the issue, > > > > Regards, > > Prakash.R > > > > > > > > > > > > On Thu, May 9, 2019 at 10:58 PM Adrian Klaver <[email protected] > > <mailto:[email protected]>> wrote: > > > > On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote: > > > Hi David, > > > > > > I did the installation for using postgresql 10.4 version edb > > standard > > > edition.so again need to run the yum command or please advise me . > > > > I don't have time to go through the below, but some issues filed at > > pgbackrest about using EDB installed database: > > > > > https://github.com/pgbackrest/pgbackrest/issues?q=is%3Aissue+edb+is%3Aclosed > > > > > > > > > > > Regards, > > > Prakash.R > > > > > > On Thu, May 9, 2019, 22:24 David Steele <[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>> wrote: > > > > > > On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote: > > > > Hi Adrian, > > > > > > > > I don't know about that client libraries can you please > > explain > > > or share > > > > me the command I will show you the output and we need the > > > solution for > > > > this pgbackrest issue . > > > > > > yum install postgresql10 > > > > > > should do it, but I thought pqlib was installed with the > > server as well. > > > Perhaps not. > > > > > > -- > > > -David > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > > > > > > > -- > > Adrian Klaver > > [email protected] <mailto:[email protected]> > > > > > > > > -- > > > > > > > > Thanks, > > Prakash.R > > PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On > > call : +91-8939599426 > > > -- > Adrian Klaver > [email protected] > -- Thanks, Prakash.R PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
