Re: perl path issue

On 5/15/19 2:37 AM, Prakash Ramakrishnan wrote: Hi Adrian, I don't much about pgbackrest i think it will take backup from archives Now only one the issue means perl cant load. I don't use pgBackRest so I am speculating now, but I believe your issue is due to mixing local and remote operation

Re: perl path issue

Hi Adrian, I don't much about pgbackrest i think it will take backup from archives Now only one the issue means perl cant load. Regards, Prakash.R On Tue, May 14, 2019 at 8:15 PM Adrian Klaver wrote: > On 5/14/19 7:40 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Prod server retention

Re: perl path issue

On 5/14/19 7:40 AM, Prakash Ramakrishnan wrote: Hi Adrian, Prod server retention periods , [global] repo1-path=/pgBACKUP/A4_sydcosafpp001 *retention-diff=3* *retention-full=1* *retention-archive=2* start-fast=y process-max=12 archive-async=y Dev server currently we dont have only restore need

Re: perl path issue

Hi Adrian, Prod server retention periods , [global] repo1-path=/pgBACKUP/A4_sydcosafpp001 *retention-diff=3* *retention-full=1* *retention-archive=2* start-fast=y process-max=12 archive-async=y Dev server currently we dont have only restore need to do prod to dev. Regards, Prakash.R On Tue, M

Re: perl path issue

On 5/14/19 7:28 AM, Prakash Ramakrishnan wrote: Yes, that is correct. How about graphical layout of your backup/restore procedure? On Tue, May 14, 2019 at 7:54 PM Adrian Klaver > wrote: On 5/14/19 2:51 AM, Prakash Ramakrishnan wrote: > Hi Ravi,

Re: perl path issue

Yes, that is correct. On Tue, May 14, 2019 at 7:54 PM Adrian Klaver wrote: > On 5/14/19 2:51 AM, Prakash Ramakrishnan wrote: > > Hi Ravi, > > > > Not , am saying we have the daily backup and full backup in prod server > > only and there is one database like a4 the db size is 1.5TB. > > so am not

Re: perl path issue

On 5/14/19 2:51 AM, Prakash Ramakrishnan wrote: Hi Ravi, Not , am saying we have the daily backup and full backup in prod server only and there is one database like a4 the db size is 1.5TB. so am not restore again in prod . Am taking directly single backup restore in dev its means in dev serve

Re: perl path issue

--- Original Message -- > On May 14, 2019, at 9:06 AM, Rob Sargent wrote: > > > Which part confused you Ravi? Same as you, this one "Am taking directly single backup restore in dev its means in dev server only restore the databa

Re: perl path issue

Which part confused you Ravi? Here’s my take > On May 14, 2019, at 4:06 AM, Ravi Krishna wrote: > >> >> >> Not , am saying we have the daily backup and full backup in prod server only >> and there is one database like a4 the db size is 1.5TB. >> so am not restore again in prod . Production s

Re: perl path issue

> > > Not , am saying we have the daily backup and full backup in prod server only > and there is one database like a4 the db size is 1.5TB. > so am not restore again in prod . > Am taking directly single backup restore in dev its means in dev server only > restore the database in new cluster.

Re: perl path issue

Hi Ravi, Not , am saying we have the daily backup and full backup in prod server only and there is one database like a4 the db size is 1.5TB. so am not restore again in prod . Am taking directly single backup restore in dev its means in dev server only restore the database in new cluster. existing

Re: perl path issue

> > 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 t

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 sin

Re: perl path issue

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-p

Re: perl path issue

Hi Ravi, I tried manually export the lib path multiple times not working. prod: ==> echo $LD_LIBRARY_PATH /usr/lib64/perl5/CORE:/opt/app/PostgreSQL/10/lib:/opt/edb/languagepack-10/Perl-5.24/lib/CORE:/opt/app/PostgreSQL/10/lib dev --- ==> echo $LD_LIBRARY_PATH /usr/lib/perl5/5.10.0/i386-linux-th

Re: perl path issue

> > ==> ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so > linux-vdso.so.1 => (0x7fffddd8f000) > libpq.so.5 => /usr/lib64/perl5/CORE/libpq.so.5 (0x7f5ecdbd6000) I may be wrong, but is the above path in the

Re: perl path issue

Hi Adrian, Please find the details, ==> ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so linux-vdso.so.1 => (0x7fffddd8f000) libpq.so.5 => /usr/lib64/perl5/CORE/libpq.so.5 (0x7f5ecdbd6000) libm.so.6 => /lib64/libm.so.6 (0x7f5ecd8d4000) libc.so.6 => /

Re: perl path issue

On 5/13/19 7:03 AM, Prakash Ramakrishnan wrote: Hi Adrian, I did in pgbackrest installation below commands in prod server. yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rp

Re: perl path issue

Hi Adrian, I did in pgbackrest installation below commands in prod server. yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rp m yu

Re: perl path issue

On 5/13/19 2:20 AM, Prakash Ramakrishnan wrote: Hi Adrian, Yes am using edb standard edition and installed pgbackrest in prod and dev. To be clear your have on the prod server: 1) Postgres installed via EDB installer. 2) You have pgBackRest. 3) You can take a backup using pgBackRest from th

Re: perl path issue

On 13/5/19 12:54 μ.μ., Prakash Ramakrishnan wrote: Hi Ravi, Please find the below details, what does : # ldd /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so say? Dev: ==> echo $LD_LIBRARY_PATH /usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:/opt/rh/rh-perl526/root/usr/lib64:/usr/lib64/pe

Re: perl path issue

Hi Ravi, Please find the below details, Dev: ==> echo $LD_LIBRARY_PATH /usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:/opt/rh/rh-perl526/root/usr/lib64:/usr/lib64/perl5/CORE:/opt/edb/languagepack-10/Perl-5.24/lib/CORE postg...@sydcosausd001.enterprisenet.org:/home/postgres Prod: ==

Re: perl path issue

> and perl DBD also installed but it cant load that is the issue please advise > me. what is the output of LD_LIBRARY_PATH on both dev and prod

Re: perl path issue

Hi Ravi, Path is there , ==> ls /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so postg...@sydcosausd001.enterprisenet.org:/home/postgres and perl DBD also installed but it cant load that is the issue please advise me. Regards, Prakash.R On Mon, Ma

Re: perl path issue

On 13/5/19 12:20 μ.μ., Prakash Ramakrishnan wrote: Hi Adrian, Yes am using edb standard edition and installed pgbackrest in prod and dev. nothing different am trying to restore the backup prod to dev cluster . * Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so' for module DBD::Pg: l

Re: perl path issue

what does ls /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so return? If there is no such file, then it means that on the dev server perl DBD was installed differently than prod. I am assuming LD_LIBRARY_PATH is also correctly set. apologize if my advise is wrong. It has been eons since I worked w

Re: perl path issue

Hi Adrian, Yes am using edb standard edition and installed pgbackrest in prod and dev. nothing different am trying to restore the backup prod to dev cluster . * 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 su

Re: perl path issue

On 5/10/19 6:49 PM, Prakash Ramakrishnan wrote: Hi Adrian, If I am following the below correctly you have EDB Postgres and pgBackRest running together on the prod server, correct? If so what was done different/is different on the dev server? 1) How was the production Postgres installed(ED

Re: perl path issue

Hi Adrian, 1) How was the production Postgres installed(EDB, native packages) and on what OS? prod has been installed edb standard edition .run file and os CENTOS 7.5 2) The dev Postgres is the one installed using EDB installer, correct? yes 3) Define working fine. In other words where you/ar

Re: perl path issue

On 5/10/19 7:50 AM, Prakash Ramakrishnan wrote: Hi Adrian, Production backup working fine now and previously dev server also working fine. Now the business team wants to restore the single database using pgbackrest tool so we have setup the pgbackrest.conf file is like to point prod . Th

Re: perl path issue

Hi Adrian, Production backup working fine now and previously dev server also working fine. Now the business team wants to restore the single database using pgbackrest tool so we have setup the pgbackrest.conf file is like to point prod . and directly restore the backup from prod so thats why no

Re: perl path issue

On 5/10/19 7:36 AM, Prakash Ramakrishnan wrote: 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

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

Re: perl path issue

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. T

Re: perl path issue

Hi Adrian, I tried below method also not working restore, ==> alias pgbackrest='export LD_LIBRARY_PATH=/usr/lib64/perl5/CORE:$LD_LIBRARY_PATH;pgbackrest' postg...@sydcosausd001.enterprisenet.org:/usr/lib64/perl5 ==> pgbackrest --stanza=A4_sydcosafpp001 --log-level-console=info --db-path=/Postgres

Re: perl path issue

Hi Adrian, Some perl path is not working here please find the below details, ==> ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so linux-vdso.so.1 => (0x7ffccf4a3000) *libperl.so => /opt/edb/languagepack-10/Perl-5.24/lib/CORE/libperl.so (0x7f9dac941000)* libpthr

Re: perl path issue

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 ins

Re: perl path issue

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 . Should have added to previous post. A heads up: Postgres 10.x is the last Linux version you can us

Re: perl path issue

On 5/9/19 9:54 AM, David Steele 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

Re: perl path issue

On 5/9/19 12:58 PM, Prakash Ramakrishnan wrote: > > 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 . It really depends on how you've installed EDB, packages or their customer installer. The custom installer

Re: perl path issue

On 5/9/19 12:58 PM, Adrian Klaver wrote: > On 5/9/19 9:54 AM, David Steele 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

Re: perl path issue

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 . So you are using the EDB installer correct? If so YUM is not going to help you. Regards, Prakas

Re: perl path issue

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 . Regards, Prakash.R On Thu, May 9, 2019, 22:24 David Steele wrote: > On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > I don't

Re: perl path issue

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

Re: perl path issue

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 . Regards, Prakash.R On Thu, May 9, 2019, 22:07 Adrian Klaver wrote: > On 5/9/19 8:12 AM, Prakash Ramakrishnan wrot

Re: perl path issue

On 5/9/19 8:12 AM, Prakash Ramakrishnan wrote: Yes, I did. The server is there, but where the client libraries installed? What does your package manager show for installed Postgres packages? postgres 12546     1  0 Apr28 ?        00:03:07 /opt/app/PostgreSQL/10/bin/postgres postgres 12554

Re: perl path issue

On 5/9/19 11:12 AM, Prakash Ramakrishnan wrote: > Yes, I did.  OK, then I would say something is wrong with your package configuration, but I don't know what it might be. Regards, -- -David da...@pgmasters.net

Re: perl path issue

Yes, I did. postgres 12546 1 0 Apr28 ?00:03:07 /opt/app/PostgreSQL/10/bin/postgres postgres 12554 12546 0 Apr28 ?00:04:12 postgres: logger process postgres 12557 12546 0 Apr28 ?01:06:28 postgres: checkpointer process postgres 12558 12546 0 Apr28 ?00:01:57 po

Re: perl path issue

On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote: > > David am trying to restore the backup in dev server please find the > below details , libpq should be installed with Postgres. Have you installed Postgres yet? -- -David da...@pgmasters.net

Re: perl path issue

Thanks, I'll check it out. David am trying to restore the backup in dev server please find the below details , [root@sydcosausd001 ~]# yum install perl perl-Time-HiRes perl-Digest-SHA perl-DBD-Pg perl-JSON-PP Loaded plugins: fastestmirror, product-id, search-disabled-repos, subscription-manager D

Re: perl path issue

On 5/9/19 9:39 AM, Adrian Klaver wrote: > On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote: >> >> We having perl issue for while during restore operation for using >> pgbackrest backup tool can you please do the needful. > > Looks to me like the Postgres client library libpq is not installed or > can

Re: perl path issue

On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote: Hi Team, We having perl issue for while during restore operation for using pgbackrest backup tool can you please do the needful. Looks to me like the Postgres client library libpq is not installed or cannot be found on this machine. You will