Re: perl path issue

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(dot)klaver(at)aklaver(dot)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_krishna(at)aol(dot)com
> > <mailto:ravi_krishna(at)aol(dot)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(dot)klaver(at)aklaver(dot)com
>

--

Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426