From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com>, Ravi Krishna <ravi_krishna(at)aol(dot)com> |
Cc: | David Steele <david(at)pgmasters(dot)net>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: perl path issue |
Date: | 2019-05-13 17:24:48 |
Message-ID: | f0c1e68a-3b7b-3bff-5249-0e48387e7459@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Julie Nishimura | 2019-05-13 17:59:22 | does postgresql backup require additional space on disk |
Previous Message | Peter Eisentraut | 2019-05-13 17:02:47 | Re: Upgrading locale issues |