Re: perl path issue

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
postgres(at)sydcosausd001(dot)enterprisenet(dot)org:
/opt/rh/rh-perl526/root/usr/lib64/perl5/CORE
==> alias pgbackrest='export
LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:$LD_LIBRARY_PATH;pgbackrest'
postgres(at)sydcosausd001(dot)enterprisenet(dot)org:
/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 <adrian(dot)klaver(at)aklaver(dot)com>
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 <adrian(dot)klaver(at)aklaver(dot)com
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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 <david(at)pgmasters(dot)net
> > <mailto:david(at)pgmasters(dot)net>
> > > <mailto:david(at)pgmasters(dot)net <mailto:david(at)pgmasters(dot)net>>> 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
> > > david(at)pgmasters(dot)net <mailto:david(at)pgmasters(dot)net>
> > <mailto:david(at)pgmasters(dot)net <mailto:david(at)pgmasters(dot)net>>
> > >
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
> >
> >
> > --
> >
> >
> >
> > 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