Hi Adrian, Yes correct am trying to restore the single database using pgbackrest command in dev.
Note - if am taking same prod single database backup and restore in new cluster no use for us and it will take more time. so business and team they need every 3 weeks for restore in dev server one single database and cant we do it in pg_dump and restore . They want using pgbackrest tool the db size is huge so tats why am trying remote restore option. dev pgbackrest.conf file ==> 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 On Mon, May 13, 2019 at 10:54 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 5/13/19 8:14 AM, Prakash Ramakrishnan wrote: > > Hi Ravi, > > > > I tried manually export the lib path multiple times not working. > > > > > ==> 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-13 19:55:05.954 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]: > > Trying to figure out above: > > sydcosausd001.enterprisenet.org is your dev > > sydcosafpp001.enterprisenet.org is your prod > > Correct? > > You are trying to run the pgBackRest on the dev machine, so why is there > a remote process failure on the prod? > > > > 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/0xc54528/pgBackRest/Db.pm line 10. > > at /loader/0xc54528/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 > > > > > > Regards, > > Prakash.R > > > > On Mon, May 13, 2019 at 8:39 PM Ravi Krishna <ravi_kris...@aol.com > > <mailto:ravi_kris...@aol.com>> wrote: > > > > > > > > ==> ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so > > > linux-vdso.so.1 => (0x00007fffddd8f000) > > > libpq.so.5 => /usr/lib64/perl5/CORE/libpq.so.5 > > (0x00007f5ecdbd6000) > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > I may be wrong, but is the above path in the LD_LIBRARY_PATH. Why do > > you expect it to be picked auto magically. > > > > > > > > > > -- > > > > > > > > Thanks, > > Prakash.R > > PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On > > call : +91-8939599426 > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Thanks, Prakash.R PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
